Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 (2)
3 Replies
Anil_Babu_Samineni
MVP
MVP

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
prasadcm
Creator II
Creator II
Author

I tried it already,doesn't work
Anil_Babu_Samineni
MVP
MVP

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful