Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

bunnyv123
Contributor

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.

Tags (1)
7 Replies
darkhorse
Valued Contributor

Re: pivot table issue for total

Hello,

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

BR

Serhan

bunnyv123
Contributor

Re: pivot table issue for total

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

bunnyv123
Contributor

Re: pivot table issue for total

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

Not applicable

Re: pivot table issue for total

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

bunnyv123
Contributor

Re: pivot table issue for total

what kind of expression can i write over there??

Not applicable

Re: pivot table issue for total

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

bunnyv123
Contributor

Re: pivot table issue for total

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 .

Community Browser