topic replacing '-' with '0' in pivot measure in App Development

replacing '-' with '0' in pivot measure

Abhi999 — Thu, 04 Jun 2020 19:43:39 GMT

I Used below expression but still it is showing '-'.

IF(ISNULL(count(order))='-', 0,count(order))

vamsee — Thu, 04 Jun 2020 20:40:02 GMT

May be try

If(Len(Trim(Order))>0, Count(Order),0)

Also, under presentation

Abhi999 — Thu, 04 Jun 2020 21:04:16 GMT

I tried this not working.

I am using qlik sense no option to replace missing values.

Saravanan_Desingh — Fri, 05 Jun 2020 13:21:44 GMT

Can you try adding this to the Expression?

Sum({1}0)

skamath1 — Fri, 05 Jun 2020 13:30:32 GMT

Try RangeSum(Count(Order),0)