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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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