New to Qlik Sense

[mstoler]

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

[tm_burgers · Accepted solution]

@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;}

[kashyap311996101 · Accepted solution]

Hi

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

thanks

[mstoler]

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

Michael

[mstoler]

This is brillant!

Thanks,

Michael