topic Re: Conditional Chart expression based on Alternate Sates Selection in QlikView

Conditional Chart expression based on Alternate Sates Selection

mkiran_18 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have 3 Multi boxes which are in 3 different alternate states.

I have a Straight table where i am calculating sum(Sales) and also Sum(Sales) for 3 different Alternate States.

I want to show Alternate states Expressions columns Sum({State 1}Sales), Sum({State 2}Sales) and Sum({State 3}Sales) only, when there is a selection from respective Multi boxes which are in 3 different alternate states. otherwise i want to show only expression Sum(Sales).

Please find the attached Application.

Thanks in Advance.

Re: Conditional Chart expression based on Alternate Sates Selection

andrey_krylov — Sat, 06 Oct 2018 20:33:08 GMT

Is this what you are looking for?

Re: Conditional Chart expression based on Alternate Sates Selection

mkiran_18 — Sun, 07 Oct 2018 05:22:16 GMT

Hi Andrey,

Thanks for your help, this is what i am looking for.

But a small doubt, in the conditional expression that you have given :

If(GetSelectedCount([Product Category], ';','STATE_1')+GetSelectedCount([Product Description], ';','STATE_1')+GetSelectedCount([Product Group], ';','STATE_1') > 0, 1, 0),

in the second parameter for GetSelectedCount, we need to pass either True/False, why did you passed ';' ?

Thanks in Advance.

Re: Conditional Chart expression based on Alternate Sates Selection

andrey_krylov — Sun, 07 Oct 2018 07:18:37 GMT

To be honest, I didn’t pay much attention to this parameter, I just used a line from some comment. But given that a non-numeric value gives false, it can be replaced with false(). Though in this case it may be better to use truth.