Qlikview usage tips- total mode & expression condition
If you need to sum under a condition and also show the total in the table, two solutions:
1.
In the Expression tab:
Definition: SUM(IF ..., 0, result )
Total Mode: Select "Expression Total"
2.
In the Expression tab:
Definition: IF ..., 0, SUM(result)
Total Mode: Select "Sum" of Rows
1.
In the Expression tab:
Definition: SUM(IF ..., 0, result )
Total Mode: Select "Expression Total"
2.
In the Expression tab:
Definition: IF ..., 0, SUM(result)
Total Mode: Select "Sum" of Rows
The information which you provides is very much useful for the Qlikview learners. Hope to get more interesting knowledge from you sir.QlikView Training in Hyderabad
ReplyDeleteThanks. QV dose have many tricks and tips, can change many impossibility to possibility.
Delete