Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Show/hide a chart upon several conditions

Hell all,

I have to add a conditionnal show/hide option of chart based on several conditions (selections of different objects).

I tried making an If Then expression but it seems not working.

Here is the formula I used:

If(GetSelectedCount([Business_Entity])=0,

     If(GetSelectedCount([Store])=0,$(v_Index_01)=1

)

Is there a problem of syntax or is it possible to have multiple conditions?

Thank you in advance.

1 Solution

Accepted Solutions
Partner
Partner

Finally, I figured out how to do the multiple conditions formatting, it is as simple as that:

$(v_Index_02)=3 and GetSelectedCount([Date])=0

So the object will appear only if the two conditions are fulfilled.

Capture.JPG

View solution in original post

4 Replies
Highlighted
Specialist
Specialist

Hello Elina,


It is possible to have a  multiple nested if conditions inside a single expression.To get more understand about your requirement, can you post a sample application and elaborate more.  Surely you will get positive reply from our community experts.


Thanks & Regards,

Venkata Sreekanth

Highlighted
Partner
Partner

Hello Venkata,

I'm new to QV and not sure how to do a sample application.

But my question is quite simple: I need to do a conditionnal show/hide based on several conditions. As for now, I know only how to add a simple condition.

Here is a screen copy:

Capture.JPG

Highlighted
Specialist
Specialist

You have to set some trigger. You can use button in the UI to show hide.

Please share your data or app.

Thank you!

Partner
Partner

Finally, I figured out how to do the multiple conditions formatting, it is as simple as that:

$(v_Index_02)=3 and GetSelectedCount([Date])=0

So the object will appear only if the two conditions are fulfilled.

Capture.JPG

View solution in original post