Table Box: Catching Null Values

[microwin88x]

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!!!

[Anonymous · Accepted solution]

In the script:

LOAD

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

*

FROM ......

NULL handling in QlikView

[MK_QSL]

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..

[its_anandrjs]

Load your table like

Load

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

From Location

Hope this helps