topic Re: Analysis problem in QlikView

Analysis problem

curiousfellow — Wed, 16 Sep 2015 19:19:06 GMT

This formula gives a correct value

Sum({$<period = {$(chosen_period)}>}value)

This function does not :

Sum({$<period <= {$(chosen_period)}>}value)

(<= instead of < )

chosen_period is a value calculated by: max(period)

period is chosen from a listbox

Is it not possible to use the <= operator ?

Re: Analysis problem

nagaiank — Wed, 16 Sep 2015 19:26:22 GMT

Try

Sum({$<period = {"<= $(chosen_period)"}>}value)

Re: Analysis problem

curiousfellow — Wed, 16 Sep 2015 19:50:55 GMT

In my chart i now get for every period lower or equal than chosen_period the value of that period.

I would like to get the selected period and the sum of values until that period

Re: Analysis problem

Oleg_Troyansky — Wed, 16 Sep 2015 19:59:53 GMT

I'm guessing from your response that period is one of your chart dimensions. If that's the case, set analysis cannot be used to select periods - the set analysis condition is only performed once per chart, not once per line.

Can you explain your need in more details? It sounds like you should use the "Full Accumulation" option, but I'm not totally sure...

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

Re: Analysis problem

sasiparupudi1 — Thu, 17 Sep 2015 06:42:46 GMT

try

Sum({1<period = {"<= $(chosen_period)"}>}value)

Re: Analysis problem

curiousfellow — Thu, 17 Sep 2015 07:53:52 GMT

The solution of NagaianK and Oleg give the right results in a simple setup, but not in the app I am building. Must have another reason. Unfortunately I cannot publish this app here.

When I use Sasidhar's formula I get the total result whithout concerning the chosen period.

Re: Analysis problem

sasiparupudi1 — Thu, 17 Sep 2015 07:57:30 GMT

may be you need to ignore other dimensions like date perhaps?

Sum({$<DATE=,period = {"<= $(chosen_period)"}>}value)

hth

Sasi

Re: Analysis problem

curiousfellow — Thu, 17 Sep 2015 08:22:18 GMT

Found that when I changed period into num(period) in my load script I get the correct results using NagaianK's formula.

Thanks to all