Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Hide sheet based on the data

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?

13 Replies
neha_shirsath
Valued Contributor

Re: Hide sheet based on the data

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

I can't see sheet2 in your app.

Not applicable

Re: Hide sheet based on the data

please press Ctrl + Shift + 'S'

Re: Hide sheet based on the data

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

Not applicable

Re: Hide sheet based on the data

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

qlikdeez
Valued Contributor

Re: Hide sheet based on the data

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

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

Not applicable

Re: Hide sheet based on the data

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.

Not applicable

Re: Hide sheet based on the data

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.

qlikdeez
Valued Contributor

Re: Hide sheet based on the data

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

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