topic User selection for list box containing or statement in QlikView https://community.qlik.com/t5/QlikView/User-selection-for-list-box-containing-or-statement/m-p/72929#M770914 <HTML><HEAD></HEAD><BODY><P>Good afternoon everyone,</P><P></P><P>I was curious if someone might be able to help me with a scripting issue. I'm trying to convert a project from Cognos to Qlikview and in the original Cognos report the prompts were as follows:</P><P></P><P>First Prompt: Division</P><P>Second Prompt: Location or Location2</P><P></P><P>The tables are currently setup as follows</P><P></P><P>Table1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Table2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>SYS_ID(PK)&nbsp;&nbsp;&nbsp;&nbsp; SYS_ID1</P><P>Location&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SYS_ID2</P><P>Division&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Location1</P><P>...&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Location2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P></P><P>Now in this case, SYS_ID matches either SYS_ID1 and/or SYS_ID2 and Location matches Location1 and/r Location2. I have concatenated Table2 so that the Location field is pulled in twice to match CD_LOC and have tried using a link table to match the data, but I was curious to see if it would be possible to setup a similar prompt (using OR) in a listbox in Qlikview? Any guidance or advice would be greatly appreciated!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT cody_summers 2020-11-25T16:16:04Z User selection for list box containing or statement https://community.qlik.com/t5/QlikView/User-selection-for-list-box-containing-or-statement/m-p/72929#M770914 <HTML><HEAD></HEAD><BODY><P>Good afternoon everyone,</P><P></P><P>I was curious if someone might be able to help me with a scripting issue. I'm trying to convert a project from Cognos to Qlikview and in the original Cognos report the prompts were as follows:</P><P></P><P>First Prompt: Division</P><P>Second Prompt: Location or Location2</P><P></P><P>The tables are currently setup as follows</P><P></P><P>Table1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Table2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>SYS_ID(PK)&nbsp;&nbsp;&nbsp;&nbsp; SYS_ID1</P><P>Location&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SYS_ID2</P><P>Division&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Location1</P><P>...&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Location2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P></P><P>Now in this case, SYS_ID matches either SYS_ID1 and/or SYS_ID2 and Location matches Location1 and/r Location2. I have concatenated Table2 so that the Location field is pulled in twice to match CD_LOC and have tried using a link table to match the data, but I was curious to see if it would be possible to setup a similar prompt (using OR) in a listbox in Qlikview? Any guidance or advice would be greatly appreciated!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/User-selection-for-list-box-containing-or-statement/m-p/72929#M770914 cody_summers 2020-11-25T16:16:04Z