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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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