Qlik Community

App Development

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

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prasadcm
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 

Labels (3)
3 Replies
Anil_Babu_Samineni

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
Creator II
Creator II
Author

I tried it already,doesn't work
Anil_Babu_Samineni

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)