Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mkiran_18
Contributor III
Contributor III

Conditional Chart expression based on Alternate Sates Selection

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.

1 Solution

Accepted Solutions
andrey_krylov
Specialist
Specialist

Is this what you are looking for?

View solution in original post

3 Replies
andrey_krylov
Specialist
Specialist

Is this what you are looking for?

mkiran_18
Contributor III
Contributor III
Author

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
Specialist
Specialist

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.