Discussion Board for collaboration related to QlikView App Development.
im getting problem in stright table subtotal and individual rows total mismatching
Example like bellow
Region10 (sub total) of bellow rows mismatching
In this im adding individual rows it shows 12 but in sub total it's shows only 10 I kept straight table expression totoa mode as expression table.
Pls can anyone guide me why its happening thanks in advance.
If you are counting based on the rows its counting the value in the row so the value is 12 . But when you are using the sub total its is adding only the distinct value , so your value is 10..
hey thx for your reply....same thing for pivot table?
In straight table change the expression totla to Sum of total. It will give you 12.
In Pivot Table you can do show sub total.
But in straight table do the "sum of rows" in Total mode under expression tab...It will give 12 as result.