topic Re: How i can add dummy Zero against some fields in QlikView

How i can add dummy Zero against some fields

sarfaraz_sheikh — Tue, 25 Aug 2015 10:10:49 GMT

Dear All,

Any idea how i can add dummy zeroes against particular fields in order to show them in table.

Any trick regards the same help would be much appreciated.

Sarfaraz

kaushiknsolanki — Tue, 25 Aug 2015 10:12:32 GMT

Hi,

What kind of data you have in that field.

If the values are null, you can use the if statement along with isnull(), something like below.

If(Isull(Field),0,Field)

To make null values as 0.

Regards,

Kaushik Solanki

Tue, 25 Aug 2015 10:12:56 GMT

Can you elaborate with sample examples what you want to get as output

krishna20 — Tue, 25 Aug 2015 10:16:40 GMT

Hi,

Goto presentation tab in the chart properties.At the bottom there is an option like Null symbol and missing symbol.There you can place '0'.

Hope it helps.

gautik92 — Tue, 25 Aug 2015 10:19:51 GMT

in script jus add if(isnull(Field),'0',field)

ashfaq_haseeb — Tue, 25 Aug 2015 10:19:53 GMT

Hi,

It depends on your requirement, if you just want to append zero before field then use below approach

Load

Field1,

0&Field1 as CustomField,

Field2

from table;

Regards

ASHFAQ

saimahasan — Mon, 02 Jan 2017 11:54:15 GMT

Hi Sarfaraz,

If your query is resolved then please close it.