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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
vvvvvvvvvv
Creator
Creator

Use zero instead of null in pivot table

Is there any way to replace '-' by 0 in QS pivot table?

I have a measure to count the number of record by using count(1). But the zero count will be shown as '-' instead of 0 .

How to display 0 for these case?

Labels (2)
11 Replies
Partha1
Contributor
Contributor

Did you find any solution for this brother? I am also facing the same issue.. 

shreyguptatechie
Contributor
Contributor

I think we have to create a loop and put 0 records in the table itself where there is no data.

Shrey