topic Re: How to replace 0 values with - in qlikview? in QlikView

How to replace 0 values with - in qlikview?

Wed, 19 Nov 2014 09:49:29 GMT

I want replace all my 0 values with - ??

Can anyone help me out

Thanks in advance,

soumya

Wed, 19 Nov 2014 09:54:41 GMT

can anyone reply soon?

Wed, 19 Nov 2014 09:56:20 GMT

Hi,

try this

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

Wed, 19 Nov 2014 09:56:55 GMT

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 — Wed, 19 Nov 2014 10:00:36 GMT

Like this

Regards

ASHFAQ

sakamsureshbabu — Wed, 19 Nov 2014 10:06:32 GMT

go presentation tab there you have "null symbol"

vikasmahajan — Wed, 19 Nov 2014 10:30:44 GMT

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

Vikas