topic Re: Pivot Chart Partial Sum problem in QlikView

Pivot Chart Partial Sum problem

rohitians — Thu, 14 Mar 2013 06:18:26 GMT

Hello,

I have a pivot chart where in i have commodities purchsed this year n last year i have their rates n quantities...i am analysing the rates if increased r decresed n in percentage wise means (current year rate - last year rate)*current year quantity I get the excess money spent compared to last year...but the partial sum for this column i am getting wrong value...i am attaching the excel format of the report please help...

Thanks and Regards,

Rohit Yadav

Re: Pivot Chart Partial Sum problem

jonathandienst — Thu, 14 Mar 2013 06:54:24 GMT

Use

Sum(Aggr(([current year rate] - [last year rate])*[current year quantity], Dimension1, Dimension2, Dimension3))

Replace the field names with the correct fields and Dimension1..Dimensionn with the chart dimensions.

Hope that helps

Jonathan

Re: Pivot Chart Partial Sum problem

rohitians — Thu, 14 Mar 2013 07:08:10 GMT

Hello,

I am calculating the rate impact as

((column(3)-column(7))*column(2))/100000

here column 3 is current year rate column 7 is last year rate and column two is current year rate..............

the calculation is cmg right but the thng is partial sum is not cmg right if see the rae imapct column in the excel sheet i want its sub total but i am not getting it...

Thanks

Re: Pivot Chart Partial Sum problem

jonathandienst — Thu, 14 Mar 2013 10:42:54 GMT

That's what the expression I posted above should do, but you cannot use Column(..) in that expression. Just replace [current year rate] with the expression for column 3, and the same with the other columns. And ensure that all the chart dimensions are incuded in the dimension list of the aggr().

Regards

Jonathan