Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jason_michaelid
Honored Contributor II

Make NULL join values selectable?

Hi all,

I'm at my wits's end with this but I bet the answer is simple! Hopefully one of you clever lot can help me...

Here is my script:

User:

LOAD User,

Name,

Colour

FROM

(ooxml, embedded labels, table is Users);

Films:

LOAD User,

Film

FROM

(ooxml, embedded labels, table is Films);

There are 5 records in the User table, and 8 in Films. User #5 doesn't have any records in Films. Therefore, I want an entry in a Films listbox with <None> that is selectable. I have tried using IsNull and LEN in the script to no avail. Help!

I've attached the qvw...

Thank you,

Jason

Tags (3)
1 Solution

Accepted Solutions
Not applicable

Make NULL join values selectable?

Hi Jason,

see the modified example (script part) and try to use MAPPING.

Good luck!

Rainer

2 Replies
Not applicable

Make NULL join values selectable?

Hi Jason,

see the modified example (script part) and try to use MAPPING.

Good luck!

Rainer

jason_michaelid
Honored Contributor II

Make NULL join values selectable?

Thank you Rainer - that worked perfectly!

Typically though, after spending DAYS on this Super Angry I found another solution just after posting my question! As I have many more tables to join, all of which might have missing values related to the mater User table I think this second way will be a bit tidier. See attached example.

Thanks again,

Jason