Good afternoon everyone,
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:
First Prompt: Division
Second Prompt: Location or Location2
The tables are currently setup as follows
Table1 Table2
SYS_ID(PK) SYS_ID1
Location SYS_ID2
Division Location1
... Location2
...
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!