topic Help with conditional show/hide based on multiple criterias in QlikView

Help with conditional show/hide based on multiple criterias

Thu, 28 May 2015 21:49:53 GMT

PFA for the application which will show the issue.

I am hoping if some one can help with the effective solution as i was trying to create multiple objects for every criteria.

Thanks.

Re: Help with conditional show/hide based on multiple criterias

Anonymous — Fri, 29 May 2015 03:17:50 GMT

Please explain your requiement clearly. Which object are you trying to show/hide and on what condition?

Re: Help with conditional show/hide based on multiple criterias

ramasaisaksoft — Fri, 29 May 2015 07:45:52 GMT

hi Dinesh Kumar,

if u want to hide any object like charts then create a button,create variables and assign variables to 0 (hide)and 1(visible) values as per your convenient

Document properties->Triggers->(Document Event Triggers)onOpen->Edit Actions->Action->Add->External->Set variable->vShowTable ->(value)0

create a button RUN and create variable vShowTable assign value to 0

add an action to button (button properties->action->add->External->Setvariable

then right hand side of Setvariable->variable name is vShowTable and value is 1

save and close u r application

open u r qvd then u will get this

if u got any issue please let me know i will attach a qvw file.

Re: Help with conditional show/hide based on multiple criterias

awhitfield — Fri, 29 May 2015 11:11:29 GMT

Hi Dinesh,

can you please clarify / expand your requirement of what you are actually trying to do, it's not very clear at present.

Andy

Re: Help with conditional show/hide based on multiple criterias

Fri, 29 May 2015 13:49:16 GMT

So When the actual application is distributed by country then we have list box for toggle between different views (Plan, target and sch views) but the sch view will be only available when the country codes are IT or FI for this reason i have created 2 list boxes where one has Plan and target for the default view for all country codes except for IT or FI where this have another list box which has plan, target and sch as i couldn't create a condition on a list box value based on the country codes.

So this way now i have %ROWKPI and %ITFIKPI views which has hide show condition based on country codes the only difference between these two is the sch view value.

Now, i want these two %ROWKPI and %ITFIKPI field value selection will show/hide three different table based on the plan view, target view and sch view selected from %ROWKPI and %ITFIKPI.

For this i have created 2 objects whcih will work when the country code is <>IT or FI then %ROWKPI=plan view then the table with the Plan view will show same thing with the country code is <>IT or FI then %ROWKPI=target view the target view will show up.

I have created another 3 more objects which satisfy the condition that country code is =IT or FI then %ITFIKPI=plan view then table with the plan view will show, country code is =IT or FI then %ITFIKPI=target view then table with the target view will show, country code is =IT or FI then %ITFIKPI=sch view then table with the sch view will show.

Here the problem is i have created multiple objects for each selection made i am not able to create a condition where i wouldn't need to have multiple objects just to satisfy this condition.

i have tried using %ROWKPI=plan view or %ITFIKPI=plan view then show plan view this was conflicting between the objects now and then as this is not an accurate condition because %ROWKPI=target view or %ITFIKPI=target view will show target view . These conditions are conflicting because or condition.

If there is a way to implement any condition on a 1 objects whether to look for whether to look for at any given time if %ROWKPI is active then take the selections from this list box or from %ITFIKPI without any conflict?

Please advise?

BTW the requirement shouldn't be done using a button just based on toggle option between plan, target, sch views.

Re: Help with conditional show/hide based on multiple criterias

Fri, 29 May 2015 15:53:36 GMT

Can any one provide some help on this please?

Re: Help with conditional show/hide based on multiple criterias

Sun, 31 May 2015 06:34:38 GMT

Hello Dinesh,

If we want to hide or show objects we can use condition in object-> layout.

Please find solution in attached QVW file.In sheet i used getselectedcount() and getfieldselctions() functions to solve.

In same way you can solve for table objects.

Re: Help with conditional show/hide based on multiple criterias

ashwanin — Sun, 31 May 2015 09:38:24 GMT

Hi,

You can display(show/hide) the Tables ,with the same method as you are displaying the List boxes based on the country code.

Here you have given conditon based on country code, for tables create variable vSHOW and put condition based on this.

Re: Help with conditional show/hide based on multiple criterias

Sun, 31 May 2015 15:14:16 GMT

All those conditions does work correctly, But i wanted to see whether the table can be conditioned based on %ROWKPI selection box and %ITFIKPI selection box as well together rather than using multiple objects based on country codes and list box selection?