Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

All values from Dimension

Hi Community,

Need to show all the values even it is null but null shouldn't show like below. Attached sample data. 

Currently :

Current.JPG

 

Looking like below:

Desired.JPG

 

_Priya

3 Replies
martinpohl
Partner - Master
Partner - Master

Hi,

In your pivot table

check supress zero values in tab presentation

and uncheck in tab Dimension Supress when value is Null

Regards

priyarane
Specialist
Specialist
Author

Ref code 5000 should not go
priyarane
Specialist
Specialist
Author

Any help on it.