2 Replies Latest reply: Jul 27, 2010 5:29 AM by Jason Michaelides RSS

    Make NULL join values selectable?

    Jason Michaelides

      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

      [D:\DATA\Jason\My Docs\Desktop\QlikView test.xlsx]

      (ooxml, embedded labels, table is Users);

      Films:

      LOAD User,

      Film

      FROM

      [D:\DATA\Jason\My Docs\Desktop\QlikView test.xlsx]

      (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