Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Honored Contributor III

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 .



1 Reply

Re: Hide missing values from Pivot Report

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.

Community Browser