Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
prasadcm
Contributor II

Hide rows with null value in Pivot table

Hello,

I am facing an issue in QlikSense where i need to hide rows with null values in  Pivot table.
I have 15 levels..but there is no data for certain levels,like in below image I have data for top 4 levels and at 15th level.
I need to hide all the blank/null rows.
Suppress null value isn't working.

 

 

pivot1.PNG

 

 

 

 

 

Regards,

Prasad

 

@sunny_talwar 

3 Replies

Re: Hide rows with null value in Pivot table

Expand the each dimension and UN-tick the "Include null values"

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
prasadcm
Contributor II

Re: Hide rows with null value in Pivot table

I tried it already,doesn't work

Re: Hide rows with null value in Pivot table

Please post some sample QVF file to test using work-around.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)