Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
try this:
if(len(yourmeasure)=0,'0',sum(YourMeasure)) in the pivot table
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