topic Re: How to conditionally show/hide objects based on maximize, minimize status in QlikView

How to conditionally show/hide objects based on maximize, minimize status

Anonymous — Wed, 19 Mar 2014 16:02:27 GMT

Hello QlikView Experts,

My humble beginnings with QlikView application development has brought me to this interesting situation. I have to create an application that should have 2 pivot tables in a single tab. But the Textboxes, current selection box etc should show selections exclusively for each pivot table selected. For this I have made use of alternate state and this works good so far. However, my second (and perhaps the only) challenge here now is how to conditionally show / hide the list boxes, selection box on this tab which will be based on the pivot table currently maximized? Just so I am making sense here: Pivot1 when maximized should show textbox1 ,selection box1 similarly Pivot2 when maximized should show textbox2, selection box2 on that same tab and automatically must hide textbox1, selection box1 etc.

I know this can be achieved using macros and I went through some forums to get around it too (eg: Text object condition based on chart object minimised/maximised status ) but I am not able to get the code to work.

Any suggestions, help will be highly appreciated!

Thanks

Nakul

Re: How to conditionally show/hide objects based on maximize, minimize status

Wed, 19 Mar 2014 16:08:51 GMT

Maybe this thread can help you out, it seems like there is an isMaximized function that can be used.

Re: How to conditionally show/hide objects based on maximize, minimize status

rwunderlich — Wed, 19 Mar 2014 16:10:20 GMT

QV11 removed the object OnActivate trigger so the referenced macro method no longer works

The only clean way to do this in QV11 is create a button that toggles a variable. Use the variable to control the visibility of the objects.

-Rob

Re: How to conditionally show/hide objects based on maximize, minimize status

alexandros17 — Wed, 19 Mar 2014 16:11:37 GMT

Here is an example

Re: How to conditionally show/hide objects based on maximize, minimize status

maxgro — Wed, 19 Mar 2014 19:37:39 GMT

you can also use nested container, see attachment (tkanks to Alessandro, I use your objects and data); in your case I probably would use variable as suggested previously

Re: How to conditionally show/hide objects based on maximize, minimize status

Anonymous — Thu, 03 Apr 2014 13:50:17 GMT

Thanks Massimo for this example! I am using your approach to have the pivot and it associated listbox, multibox, button etc , in separate container object and then adding these containers to a new container (nesting). Not sure if this optimal way to achieve the result.

Re: How to conditionally show/hide objects based on maximize, minimize status

Anonymous — Thu, 03 Apr 2014 13:58:15 GMT

Thanks Rob! I did spend some time and came up with the logic to show/hide objects based on action in Button. Eg: don't show pivot 1 when pivot 2 is visible and vice-versa. However it got bit complicated for me to extend this logic to show/hide 5 pivots. Couldn't get this logic to work using Buttons:- "if any one of other 4 pivots is currently shown , then the button should not allow showing pivot 5 and should either close the other pivot that is open or at least pop up a help text asking user to first close the xyz pivot". Basically allowing only one pivot to be seen when you have 5 pivots on the same sheet and an equal or less number of buttons to control the hide/show. I am currently using nested container approach. But please feel free to suggest.