topic Re: pivot table issue for total in QlikView

pivot table issue for total

Anonymous — Thu, 11 Dec 2014 09:31:50 GMT

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

=(if(Dimensionality()=1,

[Coperate SLP]*Performance))

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

Re: pivot table issue for total

Anonymous — Thu, 11 Dec 2014 15:47:59 GMT

Hello,

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

Serhan

Re: pivot table issue for total

Anonymous — Thu, 11 Dec 2014 16:19:58 GMT

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

Re: pivot table issue for total

Anonymous — Mon, 15 Dec 2014 11:42:36 GMT

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

Re: pivot table issue for total

Mon, 15 Dec 2014 11:46:30 GMT

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,

Re: pivot table issue for total

Anonymous — Mon, 15 Dec 2014 12:05:08 GMT

what kind of expression can i write over there??

Re: pivot table issue for total

Mon, 15 Dec 2014 12:07:32 GMT

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.

Re: pivot table issue for total

Anonymous — Mon, 15 Dec 2014 14:35:54 GMT

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 .