topic Re: Hiding / activating tables in QlikView

Hiding / activating tables

Fri, 02 Aug 2013 09:01:17 GMT

Hi,

Please can you help. I have a pie chart showing late starts for sessions, I also have a table that shows the late start reasons and details but I only want this table to appear if the user click on the pie chart or on a button to bring it up, so its hidden unless they want to see the details. How do I do this?

Thanks,

Re: Hiding / activating tables

jfkinspari — Fri, 02 Aug 2013 09:13:01 GMT

The fastest way is probably just to minimize the table (activate this in the caption tab).

When the user wants to see the details, he/she will then have to restore the minimized table by double tabbing the object,

Re: Hiding / activating tables

Siva_Sankar — Fri, 02 Aug 2013 09:13:42 GMT

pfa

Re: Hiding / activating tables

Fri, 02 Aug 2013 09:14:01 GMT

Hi,

You need to use a conditional statement on the layout tab of the graph.

You could for instance create a variable called vShowChart, have a button with an action Set Variable and assign it the value =if(vShowChart=0,1,0) and then set the condition of the graph to show as vShowChart=1.

This is probably the easiest way to accomplish this.

Lets say your pie chart is based on the field 'LateStarts'. You could also have the other chart conditionally showing on:

GetSelectedCount(LateStarts)=1

This will mean the chart will show if one of the slices is selected (at least it should)

Hope this helps!

Cheers,

Re: Hiding / activating tables

Siva_Sankar — Fri, 02 Aug 2013 09:22:47 GMT

http://community.qlik.com/thread/60267