topic Re: Null Value in Chart in QlikView

Null Value in Chart

Tue, 07 Jan 2014 16:16:26 GMT

I have created a chart and on the axis is organisation, e,g A, B and then there is -. In the table i have been able to use the presentation option to set this to Unknown. How can i do this on a chart?

Thanks

Re: Null Value in Chart

bbi_mba_76 — Tue, 07 Jan 2014 16:18:09 GMT

Hi,

in the dimension tab of the chart you could set the suppress when value is null.

Re: Null Value in Chart

Tue, 07 Jan 2014 16:21:23 GMT

Thanks for that but that actually removes this from the chart.

What i want is for this to be displayed but to replace the - with the word Unknown.

Re: Null Value in Chart

bbi_mba_76 — Tue, 07 Jan 2014 16:25:26 GMT

maybe

if(len(organisation)>0, organisation, 'Unknow')

Re: Null Value in Chart

jaimeaguilar — Tue, 07 Jan 2014 17:08:19 GMT

Hi,

There's a function called NullAsValue, which lets you substitute null values with a desired text, so you can select and trace them.

In Script you can type something like this:

NULLASVALUE FieldName1, FieldName2, ... , FieldNameN; //Here you define which fields will have text instead of missing/null

Set NullValue = 'Unknown'; // Write whatever text you want for missing/null values

After this, just load all the tables you need,

Regards

Re: Null Value in Chart

sureshbaabu — Tue, 07 Jan 2014 17:45:30 GMT

Hello,

please try the following

=if(isnull(organisation),'unknown',organisation)

Hope it helps!!!

Thanks

Re: Null Value in Chart

Wed, 19 Mar 2014 10:12:51 GMT

Hi,

Attaching qlikview file displaying gap where null is present. In this i am presenting two approaches.

Regards,

Abhishek.

Re: Null Value in Chart

amit_saini — Wed, 19 Mar 2014 10:38:02 GMT

Hi ,

Please try this:

=if(IsNull(Field),'unknown',Field)

Thanks,

Re: Null Value in Chart

Wed, 19 Mar 2014 10:41:13 GMT

Hi,

see the image.

Modify Null Symbol box as your wish like Unknown.

Regards

Kumar

Re: Null Value in Chart

PrashantSangle — Wed, 19 Mar 2014 10:48:43 GMT

Hi,

You can achieve this by,

go to Chart Properties->Presentation -> Missing Symbol and Null Symbol->write 'Unknown'

Regards,