Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

pivot table issue for total

Here in the above pivot table .... i want the [final performance] Total and the expression for it is ...

=(if(Dimensionality()=1,

  [Coperate SLP]*Performance))

  mon.PNG

in this screen shot . At Final perfromance total should be 109+0 how can i write the expression.

7 Replies
Anonymous
Not applicable
Author

Hello,

Try if(rowno()=0,...)

BR

Serhan

Anonymous
Not applicable
Author

i have tried it .. the qvw file getting terminated after that .

Anonymous
Not applicable
Author

hi can u see the issue and tell me the correct expression plss

Not applicable
Author

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!

Br,

T

Anonymous
Not applicable
Author

what kind of expression can i write over there??

Not applicable
Author

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.

BR

T

Anonymous
Not applicable
Author

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 .