Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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 (6)
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