Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

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

Kushal_Chawda

I can't see sheet2 in your app.

Not applicable
Author

please press Ctrl + Shift + 'S'

Kushal_Chawda

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

Not applicable
Author

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

Anonymous
Not applicable
Author

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

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

Not applicable
Author

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
Author

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.

Anonymous
Not applicable
Author

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

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