topic Make NULL join values selectable? in QlikView

Make NULL join values selectable?

Jason_Michaelides — Tue, 27 Jul 2010 08:41:41 GMT

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

Make NULL join values selectable?

Tue, 27 Jul 2010 09:17:28 GMT

Hi Jason,

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

Good luck!

Rainer

Make NULL join values selectable?

Jason_Michaelides — Tue, 27 Jul 2010 09:29:23 GMT

Thank you Rainer - that worked perfectly!

Typically though, after spending DAYS on this 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