Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mstoler
Partner
Partner

change display for missing values in a pivot table

Hello,

I get alot of requests to change the values for missing data (- with grey background) to just display either 0 or a white background.

 

Is there anything new that can address this below?

 

Thank You,

Michael

 

 

mstoler_0-1604595669282.png

 

2 Solutions

Accepted Solutions
tm_burgers
Creator III
Creator III

 

 

@ChristofSchwarz  just posted last month about this exact thing on his YouTube channel

https://youtu.be/9lhL3Nrel5Q

 

You can use the Styling section of the MultiKPI object to hide the grey and the dash!

 

.cell.ng-scope.null-value {background-color:rgba(0,0,255,0); color: rgba(0,0,0,0); font-size:0px;}

View solution in original post

kashyap
Partner
Partner

Hi

Try using isnull function in the expression and replace with it 0

thanks

View solution in original post

4 Replies
tm_burgers
Creator III
Creator III

 

 

@ChristofSchwarz  just posted last month about this exact thing on his YouTube channel

https://youtu.be/9lhL3Nrel5Q

 

You can use the Styling section of the MultiKPI object to hide the grey and the dash!

 

.cell.ng-scope.null-value {background-color:rgba(0,0,255,0); color: rgba(0,0,0,0); font-size:0px;}

View solution in original post

kashyap
Partner
Partner

Hi

Try using isnull function in the expression and replace with it 0

thanks

View solution in original post

mstoler
Partner
Partner
Author

I did try that but the problem is there is no data in the pivot table so it never gets evaluated.

 

Michael

mstoler
Partner
Partner
Author

This is brillant!

 

Thanks,

 

Michael