Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
priyarane
Valued Contributor

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

Re: Blanks vs 0's

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

vinieme12
Esteemed Contributor II

Re: Blanks vs 0's

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

mwoolf
Honored Contributor II

Re: Blanks vs 0's

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

priyarane
Valued Contributor

Re: Blanks vs 0's

let me try