topic Re: accumulation in chart problem in QlikView

accumulation in chart problem

Thu, 30 May 2013 10:42:40 GMT

Hello,

I am looking very long time now for an answer to my question but I can't find anything so I need your help.

I have many charts which I want to put the accumulation sum. The problem is that the accumulation sum changes with the differents filter selections.

I have 2 dimentions : Week and Product and NbVendus on expression.

For exemple:

If nothing is selected we have on week 0 for Product 1 => 1058828 (which is the accumulated sum of weeks (-25, -17, -9, - 8...0)

But if I select the weeks (-3,-2-1,0) for exemple I have 858376 for Product 1.

How I could disable the week selection in the calculation?

PFA file test

thank u

Re: accumulation in chart problem

juleshartley — Thu, 30 May 2013 10:49:00 GMT

Have you tried using set analysis? There are many threads about how to use it, but you can remove selections easily using it.

For example:

Sum (

Semaine={"*"}//Remove semaine

}

Nbvendus

)

See attached file. Note - this only removes week if you select it. If you want it to only happen under certain conditions then you will need to add an 'if' clause or similar.

Re: accumulation in chart problem

juleshartley — Thu, 30 May 2013 10:50:18 GMT

Sorry - can't seem to attach file to a reply...