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

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
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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: 
ali_hijazi
Partner - Master II
Partner - Master II
‎2011-09-09 07:42 AM

suppress rows of pivot table

Hello

I got a pivot table with 2 dimensions and 1 expressions

the expression has null values for some rows

what I want is show only rows that have non null value in the expression

how can I accomplish this?

I can walk on water when it freezes
659 Views
0 Likes
1 Reply
swuehl
MVP
MVP
‎2011-09-09 08:26 AM

I assume you have checked the usual suspects (suppress zero values in presentation tab etc.)?

If I check these options, the rows are not displayed (if there are only NULL cells in the row, I assume you have pivoted one dimension, so you got a NxM matrix?).

Regards,

Stefan

246 Views
0 Likes