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?
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.
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.