Skip to main content
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"

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

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