topic Fixed sum in pivot table in QlikView

Fixed sum in pivot table

Sun, 10 Feb 2013 07:01:22 GMT

hello all,

I fell I am this " " close to make it work but it seems that the below expression won't

You see, I want to always get the sum of the SALES field for the year 2012 of YEAR field regardless the what is the selected year. The rest of the fields (CUST, PROD, etc) may vary and affect the outcome. According to the Ref Manual this should be working... but it isn't

sum({1<YEAR={2012}>}[SALES]

)

what did I miss?

thx

Re: Fixed sum in pivot table

lironbaram — Sun, 10 Feb 2013 08:35:48 GMT

hi the expression you wrote is disregarding all selection in the model

you should try

sum({<YEAR={2012}>}[SALES]

)

Re: Fixed sum in pivot table

Sun, 10 Feb 2013 08:56:44 GMT

hello Lirin, same thing, it returns the value only when 2012 is selected for the rest I get 0

Re: Fixed sum in pivot table

lironbaram — Sun, 10 Feb 2013 09:02:36 GMT

can you post sample data

Re: Fixed sum in pivot table

Sun, 10 Feb 2013 09:14:45 GMT

here is the lay out,(data is scrabled)

Re: Fixed sum in pivot table

Sun, 10 Feb 2013 12:33:44 GMT

...sorry for my previous message, just saw that the attachement wasn't there, here it is

Re: Fixed sum in pivot table

Anonymous — Sun, 10 Feb 2013 16:04:15 GMT

Hi,

Please find the attachment of application,sales will be display for max year=2012

and reatil and service will be change according to year selection.

Regards

Re: Fixed sum in pivot table

Sun, 10 Feb 2013 16:37:22 GMT

great, thanks!