Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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