topic Re: Table Box: Catching Null Values in QlikView

Table Box: Catching Null Values

microwin88x — Tue, 01 Apr 2014 04:14:34 GMT

Hello!

I have a Table Box with many fields and one of those fields, STATUS, has different values like SELECTED, INSPECTED and there are also null values (showed as -). I'd like to change the null values in order to have something like 'TO BE SELECTED'. I believe I could do this by applying the following as a calculated dimension to STATUS: =IF(ISNULL(STATUS),'TO BE SELECTED',STATUS) but the thing is that I can't apply calculated dimensions to a Table Box...

How could I do this? What solution do you recommend me to use?

Thank you!!!

Re: Table Box: Catching Null Values

Anonymous — Tue, 01 Apr 2014 04:19:35 GMT

In the script:

LOAD

IF(Len(Trim(STATUS))=0,'TO BE SELECTED',STATUS) as STATUS,

FROM ......

NULL handling in QlikView

Re: Table Box: Catching Null Values

MK_QSL — Tue, 01 Apr 2014 06:18:00 GMT

You can do the same using below

Script Side

Change your STATUS line as

IF(LEN(TRIM(Replace(STATUS,'-','')))=0,'TO BE SELECTED',STATUS) as STATUS

UI SIDE (in Listbox, Calculated Dimensions)

IF(LEN(TRIM(Replace(STATUS,'-','')))=0,'TO BE SELECTED',STATUS)

Hope this helps..

Re: Table Box: Catching Null Values

its_anandrjs — Tue, 01 Apr 2014 06:29:38 GMT

Load your table like

Load

IF(STATUS= '-', 'TO BE SELECTED',STATUS) AS NewStatus

From Location

Hope this helps