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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide sheet for null field

Hi friends,

I have two sheet,Sales and Finance, in sales I have data in fields, but in finance i have no data in fields. I want to hide the sheet for finance because its fields dont have data but when the field will get data that sheet will be shown

PFA to test

5 Replies
maleksafa
Specialist
Specialist

try this one, i have created a variable vCount that get the count of AA + BB + CC + DD, and in the sheet expression i set it to conditional where vCount > 0

Not applicable
Author

I just attached a sample file but in real i have more than 50 fields then how is this possible to do

Not applicable
Author

Thanks anyway I got the solution

maleksafa
Specialist
Specialist

can you share it ?

Not applicable
Author

Please find the attachment