Qlik Community

Qlik Sense App Development

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

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator 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
Highlighted

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)
Highlighted
Creator II
Creator II

I tried it already,doesn't work
Highlighted

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)