Conditional Chart expression based on Alternate Sates Selection

[mkiran_18]

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.

[andrey_krylov · Accepted solution]

Is this what you are looking for?

[mkiran_18]

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.

[andrey_krylov]

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.