topic Re: Pivot Table in QlikView

Pivot Table

Anonymous — Tue, 04 Dec 2012 20:09:57 GMT

Hello there,

I got help last time to build a total on a pivot table. Now I need more help to make the sum of the totals. On the attachment there is an example.

This is the expression for the total on the Class level.

How can I have the Total on the Category level?

The result of both totals must be 21600+29700=51300

Thanks in advance.

Re: Pivot Table

MayilVahanan — Tue, 04 Dec 2012 22:22:43 GMT

Try like this

=if(rowno()=0 or IsNull(RowNo()),SUM(AGGR((sum(Amount)-(Value*max(total<Category>aggr(SUM(Amount),Category,Class,Code))/1000))*Price,Type,Category,Class,Code)),Column(6)*Column(7))

Re: Pivot Table

Anonymous — Wed, 05 Dec 2012 02:42:12 GMT

Thanks Mayil

It works nice!