Sense: Show Missing as 0

[ift_isabelle]

Hi,

We have a table with Finance Data for ever Cost Center and Ledger over months.
In some months there is no expense on that specific  CostCenter or ledger and Qlik Sense shows it as missing.
We want to show this as 0 instead of -, but because of the lack of data in the month and the existing data in total, the missing won't change to 0. I have tried ALT, ISNULL, Count on Ledgers.

Anyone an idea how to do this in Sense?

Kind Regards,
Isabelle

[juliensaintmaxent3113]

Hello Isabelle,

the problem is that there is no existing line in the data. the only way i see is to create its lines either with a load inline (with the right fields and the value at zero) or an external file.

Have a nice day.

Bye

[ift_isabelle]

So there is no way to adjust the layout? Because that is exactly all I want...

[juliensaintmaxent3113]

try this:

if(len(yourmeasure)=0,'0',sum(YourMeasure)) in the pivot table

[ift_isabelle]

I tried that already. Doesn't work.
Problem is that my measure is longer then 0, but in the month january it is null(). We tried aggregating it to month, still no result...

[juliensaintmaxent3113]

i think there aren't answers directly in the visualization for your problem

Try to replace "-" by "0" with add missing data

You can try the method in attached file

[ift_isabelle]

Ok, we will discuss if we want to change our datamodel or leave the Null() in the table.