topic Null values script in QlikView

Null values script

Anonymous — Thu, 12 Jan 2017 14:11:22 GMT

Hi,

I have a field "Saksnr" that contains null values and some of the collums has numeric values.

I want to sort this out like this:

is not null values = "Purret"

and

isnull values = "Inkasso"

rename the field to Status, and use it as a listbox for selection between "purret" and "inkasso".

annafuksa1 — Thu, 12 Jan 2017 14:13:05 GMT

try

if(isnull(Saksnr), 'Inkasso','Purret') as Status

sunny_talwar — Thu, 12 Jan 2017 14:13:24 GMT

May be like this:

LOAD Saksnr,

If(Len(Trim(Saksnr)) = 0, 'Inkasso', 'Purret') as Status,

...

FROM ....;

Anonymous — Thu, 12 Jan 2017 14:16:22 GMT

Perfect ! Thanks 🙂