Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi qlikview community,
I am having a proble with the partial sum on my pivot table. The partial sum is diffrent from the sum of rows in my chart. I display my expression above:
if( b.Year < SubField(vTODAY,'-',1),sum(b.NetSalesValue),if(b.Month < SubField(vTODAY,'-',2),sum(b.NetSalesValue),sum((aggr(sum(b.ForecastQty),b.CustomerClassDescription,b.ProductClassDescription,b.CustomerName,b.YearMonth) * Price) / ExchangeRate)))
My dimensions are: b.CustomerClassDescription,b.ProductClassDescription,b.CustomerName,b.YearMonth
I recon that this is because of the aggregation somehow . Any ideas ho to fix that???
Regards
I manage to reproduce the correct parial sums by altering my expressions similar to the above:
sum(if( b.Year < SubField(vTODAY,'-',1),b.QtyInvoiced,if(b.Month < SubField(vTODAY,'-',2),b.QtyInvoiced,b.ForecastQty)))
I get the same thing with my quantity expression too eventhough i dont use aggr....
=if( b.Year < SubField(vTODAY,'-',1),sum(b.QtyInvoiced),if(b.Month < SubField(vTODAY,'-',2),sum(b.QtyInvoiced),sum(b.ForecastQty)))
Anyone that can help....
I manage to reproduce the correct parial sums by altering my expressions similar to the above:
sum(if( b.Year < SubField(vTODAY,'-',1),b.QtyInvoiced,if(b.Month < SubField(vTODAY,'-',2),b.QtyInvoiced,b.ForecastQty)))