Hide missing values from Pivot Report - Qlik Community

vikasmahajan · ‎2013-07-24

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.

tresesco · ‎2013-07-24

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.