topic Re: Hiding list box based on a condition in QlikView

Hiding list box based on a condition

rsdhavle — Fri, 27 Dec 2013 10:32:02 GMT

There are two buttons and two list boxes in my dashboard. When i click on one button i need to hide one list box. Is that feasible by putting condition?

Re: Hiding list box based on a condition

Gysbert_Wassenaar — Fri, 27 Dec 2013 10:35:53 GMT

Yes, create a variable vShowHideMe and add a Set Variable action to the button to set that variable to 'Hide'. Then open the properties window of the listbox. Go to the Layout tab, select Conditional (under Show) and enter the expression =if(vShowHideMe = 'Hide', 0, 1). Now if you click the button the value in the variable should change to Hide and the listbox should be hidden. See attached example.

Re: Hiding list box based on a condition

suresh_rawat — Fri, 27 Dec 2013 10:51:39 GMT

Hi Rohan,

Yes it is feasiable in qlikview.

Kindly refer the attached qvw.

Regards

Suresh Rawat

Re: Hiding list box based on a condition

rsdhavle — Fri, 27 Dec 2013 12:30:20 GMT

Thanks. Its is working..One more query i wanted to ask. Suppose i am passing two actions in one button. Can both actions be executed together?

Re: Hiding list box based on a condition

Fri, 27 Dec 2013 12:42:45 GMT

Yes

it will work.any other trigger u can apply

Re: Hiding list box based on a condition

Fri, 27 Dec 2013 12:48:42 GMT

Hi Rohan,

if u get clarified u r doubt then close the thread it will be helpful for users.

regards

Mahesh T

Re: Re: Hiding list box based on a condition

suresh_rawat — Sat, 28 Dec 2013 03:04:22 GMT

Hi Rohan,

As per my understanding, you have 2 list box and 1 button.

On click of that button one list box should show and one should hide and vice-versa.

For this kindly refer the attached qvw.

If you want something else, please elaborate.

Regards

Suresh Rawat

Re: Re: Hiding list box based on a condition

Sat, 28 Dec 2013 13:23:09 GMT

Hi Rohan,

Helpful example..

Using Actions For Hiding Sheets

Here are some examples of text boxes performing the actions of buttons. These examples place values into variables, which are then used to do something dynamic in the app.

In most of the QlikView apps I produce I have some tabs for system data that is hidden from most users. To implement this I set a variable in the load script:

let vShowDev = 0;

On the front sheet there is then a text box that has dynamic text:

=if (vShowDev = 0, 'Show', 'Hide') & ' Development Tabs'

And finally there is an Action to set the value of the variable:

=if(vShowDev = 0, 1, 0)

The toggle on the screen looks inconspicuously like this:

All that is left then is to put the Conditional Show criteria on the correct sheets. The code for this is simply:

vShowDev = 1