topic Re: Hide sheet based on the data in QlikView

Hide sheet based on the data

Wed, 19 Jul 2017 07:30:38 GMT

Dear Team,

Please see my qlikview file. basically the chart in the sheet named 'sheet2' contains no data. May i know how do i hide the sheet if the chart inside contains no data?

Re: Hide sheet based on the data

neha_shirsath — Wed, 19 Jul 2017 07:33:39 GMT

Hi,

Please see below links it might b helpful for you-

https://community.qlik.com/thread/261322

https://community.qlik.com/thread/124032

Thanks,

Neha

Re: Hide sheet based on the data

Kushal_Chawda — Wed, 19 Jul 2017 07:43:04 GMT

I can't see sheet2 in your app.

Re: Hide sheet based on the data

Wed, 19 Jul 2017 07:47:15 GMT

please press Ctrl + Shift + 'S'

Re: Hide sheet based on the data

Kushal_Chawda — Wed, 19 Jul 2017 07:48:25 GMT

I know this but, there is no sheet with name "sheet2"

Re: Hide sheet based on the data

Wed, 19 Jul 2017 07:59:44 GMT

sorry. my mistake. should be 'Chart 2' what i want is hide the chart 2 as you can see the chart in the chart 2 sheet contains no data

Re: Hide sheet based on the data

Anonymous — Wed, 19 Jul 2017 08:06:35 GMT

Do you want to hide 'Chart 2' if no Job # is selected?

When the user selects the Job #, 'Chart 2' becomes available?

Re: Hide sheet based on the data

Wed, 19 Jul 2017 08:11:42 GMT

actually this qlikview file is show on TV screen. It auto switch to next sheet every 15 seconds. If you hide the sheet then you will see the effect. But now what i want to do is, whenever chart in the chart 2 sheet empty. I want to hide the chart 2 sheet.

Re: Hide sheet based on the data

Wed, 19 Jul 2017 08:29:35 GMT

or instead of checking contain. can we update a variable once data loaded? i am thinking to have a variable to hold number of sheet to be displayed. what i want is when data loaded or file opened. i want to count my record and update the variable.

Re: Hide sheet based on the data

Anonymous — Wed, 19 Jul 2017 08:34:51 GMT

o you want to hide 'Chart 2' if NO Job # is selected?

When the user selects the Job #, 'Chart 2' becomes available?

Re: Hide sheet based on the data

Wed, 19 Jul 2017 08:36:44 GMT

no. what i want is as i already set the condition in the dimension. if no data display in the chart. i want to hide chart 2

Re: Hide sheet based on the data

mangalsk — Wed, 19 Jul 2017 09:33:39 GMT

PFA i tried and it is working, check if it is as you require

Re: Hide sheet based on the data

Siva_Sankar — Wed, 19 Jul 2017 09:41:25 GMT

Hi Chee Hang Lim,

Find the attached qlikview file, you need to use the condition below under layout tab.

=if(isnull(If(VS='VSR' and No=2, JOB_NO )),0,1)

Re: Hide sheet based on the data

mangalsk — Thu, 20 Jul 2017 05:49:20 GMT

This is what i did in attached qvw