topic sum changes with time in QlikView

sum changes with time

Mon, 26 May 2014 11:24:18 GMT

hi guys,

I i've a chart wich display a year to date information, my problem is when i select several month's my Production costs information is incorrect but when i only choose one month it's correct, it seems to be doing some kind of average or something.

My expression: =sum({$ <Responsible = {"=RaiserPlantID=Responsible"}>} Auth*XRATE2USD)

When several Months are selected:

when only jan is selected:

as you can see the amounts are incorrect when several month are selected.

Re: sum changes with time

Gysbert_Wassenaar — Mon, 26 May 2014 12:03:55 GMT

The problem is likely your set modifier Responsible = {"=RaiserPlantID=Responsible"}. The set is calculated for the entire chart, not a set per month. Perhaps you need to use an if statement instead. Perhaps this document helps understanding what's going on: set_analysis_intra-record.qvw

Re: sum changes with time

Mon, 26 May 2014 13:03:26 GMT

What you are saying it's the chart only set analyses once and i need it to do it per month, do you have suggestion how to accomplish with a if stat?

Re: sum changes with time

Gysbert_Wassenaar — Mon, 26 May 2014 13:05:32 GMT

Try sum(if(RaiserPlantID=Responsible,Auth*XRATE2USD,0))

Re: sum changes with time

Mon, 26 May 2014 13:27:11 GMT

Thanks it worked, i had already tried something near your expression but the result was the same but at the time i couldn't understand the problem after your explanation the if statement makes sense. Thanks