topic Re: pivot table sum problem in QlikView

pivot table sum problem

Wed, 06 Nov 2013 10:24:19 GMT

Hi all,

I am trying to get the sum of the pivot table expression:

Total + if(b.Year= Year(vTODAY) and num(b.MonthName) >= num(Month(vTODAY)),Forecast,0)

Where Total and Forecast are two other expression.

And my dimentions are b.CustomerClassDescription,b.ProductClassDescription,b.CustomerName,b.YearMonth

It seems corrent on an individual month basis but the acutal total number is wrong.

Can anyone help??

tresB — Wed, 06 Nov 2013 10:33:04 GMT

Could you post a sample that demontrates the issue?

Wed, 06 Nov 2013 10:40:22 GMT

Hi there here is a sample image.

What i actually want is to the FY13Estimate to be the Actual + Forecast for (November and Decembe)

tresB — Wed, 06 Nov 2013 11:34:58 GMT

Your expressions and dimensions would play a big role to suggest a solution. Please refer Preparing examples for Upload - Reduction and Data Scrambling and share your sample app.

Wed, 06 Nov 2013 11:55:21 GMT

Oh have not seen that, I will have that in mind next time.

I finaly managed to solve the issue but the expression is a bit compicated to post.

Thanks for the helping anyway