topic Re: Missing data - Nulls? in QlikView

Missing data - Nulls?

bazzaonline — Mon, 16 Feb 2015 09:33:35 GMT

Hello,

Really new to this and need to work out how to replace empty field with defined text in the script.

Example attached, where this is no name eg ' - ', how can I replace this in the script to a default, for example 'Temp'?

Make 5 and 6 have Temp in Responsible??

Anonymous — Mon, 16 Feb 2015 09:37:10 GMT

Try something like this in you load script.

LOAD Activity,

if ( isnull (Responsible) , 'Temp' , Responsible ) as Responsible

FROM

(ooxml, embedded labels, table is Sheet1);

tyagishaila — Mon, 16 Feb 2015 09:38:58 GMT

Go to Chart Properties>> presentation Tab

There are two options 1 for NULL Symbol and another for Missing Symbol.

You can Type there whatever you want in place of missing symbol/Null symbol.

I hope your problem will resolve.

AbhijitBansode — Mon, 16 Feb 2015 09:49:24 GMT

The best way to deal with NULLs is:

LOAD Activity,

if ( Len (Responsible) <1, 'Temp' , Responsible ) as Responsible

FROM

(ooxml, embedded labels, table is Sheet1);

Mon, 16 Feb 2015 10:04:26 GMT

Hi Paul

goto: point to the chart->chart properties->Presentation (tab)-> Null Symbols=Temp /Missing Symbol = Temp.

this is the easiest way, otherwise you can perform this in your script as Abhijit suggested or in you chart dimensions put a an if condition .

Hope this helps

Best Regards

Dlamini