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