Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Sept. 27, 10AM ET Do more with Qlik, Insight Advisor – our intelligent AI-assistant in Qlik Sense: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
prasadcm
Creator II
Creator II
‎2019-03-07 10:59 AM

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)
Labels
1,200 Views
0 Likes
3 Replies
Anil_Babu_Samineni
MVP
MVP
‎2019-03-08 03:27 AM

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)
1,184 Views
0 Likes
prasadcm
Creator II
Creator II
‎2019-03-08 07:35 AM
Author

In response to Anil_Babu_Samineni
I tried it already,doesn't work
1,175 Views
0 Likes
Anil_Babu_Samineni
MVP
MVP
‎2019-03-08 08:11 AM

In response to prasadcm

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)
1,170 Views
0 Likes