Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
marius_larsen
Contributor II

Null values script

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

1 Solution

Accepted Solutions

Re: Null values script

May be like this:

LOAD Saksnr,

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

          ...

FROM ....;

3 Replies
annafuksa1
Contributor III

Re: Null values script

try

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

Re: Null values script

May be like this:

LOAD Saksnr,

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

          ...

FROM ....;

marius_larsen
Contributor II

Re: Null values script

Perfect ! Thanks 🙂