topic some quick help from you in QlikView

some quick help from you

Mon, 14 Jul 2014 07:44:05 GMT

pivot table calculation issues

I created a pivot but I couldnot able to get the exact result

can you guide me to get the exact one

I am using the following expression

IF(Match(ServiceOLR.Type,'Budget','Actuals'), NUM(SUM(ServiceOLR.Amount), '#,##0'),

IF(Match(ServiceOLR.Sub_Region, 'SOUTH PACIFIC'), NUM(SUM({$<ServiceOLR.Sub_Region={'SOUTH PACIFIC'}, ServiceOLR.Type={'Budget'}, ServiceOLR.PL={'MG','9R'}>}ServiceOLR.Amount/100), '#,##0%'), NUM(SUM(ServiceOLR.Amount)/100, '#,##0%')),

)

Re: some quick help from you

Anonymous — Mon, 14 Jul 2014 19:39:13 GMT

In pivot its doing sum of rows. Try using Straight table and see what you are getting.

Partial sums always works wierd in Pivot

Re: some quick help from you

Anonymous — Mon, 14 Jul 2014 19:40:45 GMT

Basically you are looking for "Expression Total" which you will get in Straight but in Pivot you are getting "Sum of Rows" weird though