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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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