Discussion board where members can learn more about Qlik Sense App Development and Usage.
When I do a count(fieldname) and I get missing values "-" in my pivot table. How do I replace those with 0s.
I provided a screenshot with the missing values which I would like to replace as 0s.
I have not been able to figure out a way to do that. I think we are stuck with the '-'. I have posted the same question previously with no work around.
That's a bummer, I hope someone has some insight on this.
You can try this expression..
Thanks for the reply. I tried that calculation and still it does not work.
It will work this way,
If (Sum(Sales) =0, ' ', Sum(Sales)) in the Pivot expression.
~ Ravi Kancharla
Thanks for replying . I tried that calculation and that didn't work as well .