Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Abhi999
Contributor III
Contributor III

Replacing '-' with '0' in pivot table

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

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

1 Reply
Durgadevikumar
Partner - Contributor III
Partner - Contributor III

Hey Abhi,

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

If the order field having multiple null values(-) then count of order produce the count is does not gives the (-) . so automatically it provides the count of order as a output.

So Try this simple if condition,

=if(Order = '-', 0 , count(Order))  // if the order field has - it replace those value with 0 or else give the count of order

Regards,

Durga