Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Pivot table missing values

Hi,

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.

Thank you

6 Replies
rittermd
Honored Contributor

Re: Pivot table missing values

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.

Not applicable

Re: Pivot table missing values

That's a bummer, I hope someone has some insight on this.

chooco_co
Valued Contributor

Re: Pivot table missing values

Hi Ismael,

You can try this expression..

if(count(fieldname)=null(),0,count(fieldname))


Regards,

Marco

Not applicable

Re: Pivot table missing values

Hi Marco,

Thanks for the reply. I tried that calculation and still it does not work.

Not applicable

Re: Pivot table missing values

Hi Ismael,


It will work this way,


If (Sum(Sales) =0, ' ', Sum(Sales)) in the Pivot expression.


~ Ravi Kancharla


Not applicable

Re: Pivot table missing values

Hi Kancharla,

Thanks for replying . I tried that calculation and that didn't work as well .

Ismael

Community Browser