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

Comments

  1. 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

    ReplyDelete
    Replies
    1. Thanks. QV dose have many tricks and tips, can change many impossibility to possibility.

      Delete

Post a Comment

Popular posts from this blog

install ipython in Cloudera VM using pip

install postgreSQL in ubuntu 16.04

Install MYSQL 5.6 in ubuntu 12.04/14.04 and set password and remote access