Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

Blanks vs 0's

Hi Community,

I am using pivot table and I need 0's to be populated not the blanks. If I select the option suppress zeros then both are going.

how to get 0's not the blanks.

_Priya

4 Replies
sunny_talwar

May be convert 0s to 0.00000001 and use dual function to display them as 0

vinieme12
Champion III
Champion III

try the below sample

Load * inline [

DIM,Sale

A,100

B,0

C,150

E,

F,200

G,0

H,

];

Create a straight table with DIM as dimension and below expression

Dual(

(sum(Sale))

,

sum(if(Sale=0,0.001,Sale)))

Now E and H which have null values will be hidden and B and G which have zero values will still be shown

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
m_woolf
Master II
Master II

If you really have blanks (nulls), can you just change the Null Symbol to 0?

priyarane
Specialist
Specialist
Author

let me try