Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Abhi999
Contributor III
Contributor III

replacing '-' with '0' in pivot measure

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

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

4 Replies
vamsee
Specialist
Specialist

May be try

 

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

 

Also, under presentation

vamsee_0-1591303191311.png

 

 

 

Abhi999
Contributor III
Contributor III
Author

I tried this not working.

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

Saravanan_Desingh

Can you try adding this to the Expression?

Sum({1}0)
skamath1
Creator III
Creator III

Try  RangeSum(Count(Order),0)