topic Re: calculation issue in QlikView

calculation issue

Tue, 31 May 2016 08:18:03 GMT

I have below expression as calculation.

Sum({<Flag={'1'}>}Value) but when other value is selected from flag it should display the result for that.

Re: calculation issue

andrespa — Tue, 31 May 2016 15:16:13 GMT

Hi, maybe you have a conceptual problem? That expression always give you back the result of having Flag=1 no matter what other value of Flag you select.

Best regards,

Andrés

Re: calculation issue

Anonymous — Tue, 31 May 2016 15:20:58 GMT

Hi Chang,

You will always get the sum of selections of Value when Flag = 1, but if you want for every selections ever, you may use this Sum({1<Flag={'1'}>}Value)

Thanks!

Re: calculation issue

sunny_talwar — Tue, 31 May 2016 15:24:18 GMT

May be this:

If(GetSelectedCount(Flag) = 0, Sum({<Flag={'1'}>}Value), Sum(Value))

Re: calculation issue

Wed, 01 Jun 2016 06:16:34 GMT

Let me clear it again.. current expression gives the value for Flag=1 but there could be other values too in Flag filed like 2,3,4. So when I select Flag=2 it should display value for Flag=2

Hope it is clear now

Re: calculation issue

Kushal_Chawda — Wed, 01 Jun 2016 06:26:23 GMT

Not sure but may be this

Sum({<Flag *={'1'}>}Value)

Re: calculation issue

Anonymous — Wed, 01 Jun 2016 06:50:27 GMT

Hi Chang Din,

There is two ways:

Sum({<Flag={$(=Max(Flag))}>}Value) or Sum(Value)

Regards

Re: calculation issue

sasiparupudi1 — Wed, 01 Jun 2016 10:00:19 GMT

remove Flag from the set analysis and the sum should display values according to the value selected in the flag

Sum(Value).

Other option could be is to set a variable in input box

vFlag with values as 1,2,3,4,5

in the expression Sum({<Flag ={'$(vFlag)'}>}Value)

hth

Sasi