topic Hiding an object with a selection without using a text box for hiding in QlikView

Hiding an object with a selection without using a text box for hiding

Wed, 25 Nov 2020 16:16:04 GMT

All,

I would like to select a "Goal" in the Goals listbox, as so:

and change this layout

to this layout

Does anyone know how I could accomplish this?

Thanks in Advance,

Preston

tamilarasu — Thu, 31 Mar 2016 02:21:33 GMT

Hi Preston,

You can use below expression in Conditional show property of the chart. Check the attachment and adapt the same for all charts.

=Count(DISTINCT {<Type={'Measure'},ID={'1.2*'}>} [Measure Name])

uacg0009 — Thu, 31 Mar 2016 02:59:52 GMT

Hi Preston,

And I also think that you can create a variable, for example named v1,

then using :

v1=if(Goals='Mission Specific',1,0)

then using the v1=1 then show the Mission Measures in condition.And 0 show another list box.

Aiolos Zhao

Fri, 01 Apr 2016 14:48:17 GMT

Thanks Tamil for the solution! I really appreciate it.

Regards,

Preston

Fri, 01 Apr 2016 14:49:34 GMT

Aiolos,

I never thought about using the variable, but I think I'll combine it with Tamil's answer above to really work some mags with what I'm trying to do.