Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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
Not applicable
Author

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

mangalsk
Creator III
Creator III

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

Siva_Sankar
Master II
Master II

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)

Capture.JPG

mangalsk
Creator III
Creator III

This is what i did in attached qvw