Show/hide a chart upon several conditions

[edemerdjieva]

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.

[Anonymous]

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

[edemerdjieva]

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:

[isingh30]

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

Please share your data or app.

Thank you!

[edemerdjieva · Accepted solution]

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.