topic Re: Blanks vs 0's in QlikView

Blanks vs 0's

priyarane — Fri, 11 Aug 2017 11:52:37 GMT

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

sunny_talwar — Fri, 11 Aug 2017 12:38:16 GMT

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

vinieme12 — Fri, 11 Aug 2017 13:08:55 GMT

try the below sample

Load * inline [

DIM,Sale

A,100

B,0

C,150

F,200

G,0

];

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

m_woolf — Fri, 11 Aug 2017 15:20:10 GMT

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

priyarane — Fri, 11 Aug 2017 16:03:52 GMT

let me try