Discussion Board for collaboration related to Creating Analytics for QlikView.
Here in the above pivot table .... i want the [final performance] Total and the expression for it is ...
in this screen shot . At Final perfromance total should be 109+0 how can i write the expression.
i have tried it .. the qvw file getting terminated after that .
hi can u see the issue and tell me the correct expression plss
Did you use an aggregation or sum function in the Final Performance expression? Wihout them, in the pivot table subtotals won't be shown. Put it in your expression, and let us know what are the results!
what kind of expression can i write over there??
It depends on what you want to represent there. Just an example: sum(Performance)
The main idea is to use some kind of aggregation function, because that is a requirement for subtotals to appear in a pivot table.
as i want to make aapear the grand total as dimensionality()=0 .
how can i write the expression over there according to the screen shot .