topic Re: Show/hide a chart upon several conditions in QlikView

Show/hide a chart upon several conditions

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

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.

Re: Show/hide a chart upon several conditions

Anonymous — Mon, 05 Mar 2018 16:45:36 GMT

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

Re: Show/hide a chart upon several conditions

edemerdjieva — Mon, 05 Mar 2018 16:51:21 GMT

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:

Re: Show/hide a chart upon several conditions

isingh30 — Mon, 05 Mar 2018 16:53:52 GMT

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

Please share your data or app.

Thank you!

Re: Show/hide a chart upon several conditions

edemerdjieva — Wed, 07 Mar 2018 13:40:36 GMT

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.