Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
marius_larsen
Creator II
Creator 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
sunny_talwar

May be like this:

LOAD Saksnr,

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

          ...

FROM ....;

View solution in original post

3 Replies
annafuksa1
Creator III
Creator III

try

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

sunny_talwar

May be like this:

LOAD Saksnr,

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

          ...

FROM ....;

View solution in original post

marius_larsen
Creator II
Creator II
Author

Perfect ! Thanks 🙂