Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sarfaraz_sheikh
Contributor III
Contributor III

Hiding null value at dimension level in Pivot table

Dear All,

In my below image i do not want   below Delhi in Ergo_loc as dimension..However i want to show blank values column like FNon_contactable ,ELead_pending without underwriter  ..but i do not want in Ergo_loc...I tried but failed..

LMS_1.png

Kindly help if any solution ....My qvw is also attached here for your refernece ...

Sarfaraz

14 Replies
sarfaraz_sheikh
Contributor III
Contributor III
Author

kindly reply if know the solution ..........

Sarfaraz

pokassov
Specialist
Specialist

Hello!

Can you change ERGO_LOC as dimension to calculated dimension

=if(IsNull(ERGO_LOC),' ',ERGO_LOC)

with lable

ERGO_LOC ?

sarfaraz_sheikh
Contributor III
Contributor III
Author

did not work ....have observation in below image...

LM_2.png
sarfaraz

awhitfield
Partner - Champion
Partner - Champion

The - values are actually 'MISSING rather than 'NULL'

Andy

sarfaraz_sheikh
Contributor III
Contributor III
Author

Dear Andrew,

How to suppress that missing ....any help would be more appreciated

Sarfaraz

awhitfield
Partner - Champion
Partner - Champion

If you tick 'Populate Missing Cells' on the presentation tab they will appear as blank instead of -

sarfaraz_sheikh
Contributor III
Contributor III
Author

dear anderw ,

id did not work .......want to hide missing cell ....

sarfaraz

pokassov
Specialist
Specialist

I don't get what you want...

Not applicable

Hi,

Please check 'Suppress when value is null' for ERGO_LOC dimension. It should work.