Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Partner
Partner

Sense: Show Missing as 0

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,
IsabelleScreenshot.png

Labels (4)
6 Replies
Partner
Partner

Re: Sense: Show Missing as 0

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

Partner
Partner

Re: Sense: Show Missing as 0

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

Re: Sense: Show Missing as 0

try this:

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

Partner
Partner

Re: Sense: Show Missing as 0

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...
Partner
Partner

Re: Sense: Show Missing as 0

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

Partner
Partner

Re: Sense: Show Missing as 0

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