Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

Hide missing values from Pivot Report

Dear all

I have pivot report I want to hide all values having zero's or null or -  in  , I tick option supress when values is null 

option but still I am not able to hide this values.

please help me to achive the same .

Thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
1 Reply
tresesco
MVP
MVP

This does not work because, if one of your fields has 0 or '-' or NULL the other field has value for that record. if you want to hide the row for a certain field's content (0 or null or '-') then you have to put a conditional expression(presentation tab) for all the columns with same expression.

Hope this helps.