How to replace 0 values with - in qlikview?

[#1]

Hi

I want replace all my 0 values with - ??

Can anyone help me out

Thanks in advance,

soumya

[#2]

can anyone reply soon?

[#3]

Hi,

try this

If(fieldvalue=0,'-',Fieldvalue) as new_fieldname

[#4 · Accepted solution]

Hi soumya,

if you want to replace your values with zero then you can use

if(sum(sales)=0,'_',sum(sales)),

Here sum(sales) can be replaced with any value you want to check,

but if you dont want to show the values in the chart, you can go the presentation tab and put the checkbox on the suppress zero values.

if you want it in the script the above formula will do the work.

With Regards

Harshita Gaur

[ashfaq_haseeb]

Like this

Regards

ASHFAQ

[sakamsureshbabu]

go presentation tab there you have "null symbol"

[vikasmahajan]

In Dimension you can press supress null option to avoid null or zero values in chart

Vikas