topic Re: Include only certain values in script in QlikView

Include only certain values in script

evansabres — Wed, 24 Oct 2018 14:16:32 GMT

In my script, I want to have a condition where I keep only certain values. At the end of my script I have FROM [Data Source......] WHERE(team = 'ABC') and (team = 'DEF')......and this repeats eight more times. The script does not function at that point. Is there a more efficient way to do this>?

Re: Include only certain values in script

Anonymous — Wed, 24 Oct 2018 14:38:03 GMT

try use of match

where match(team,'ABC','DEF','GHI')>0

-> add more conditions

suppose you want not Team = 'ABC' and Team = 'DEF' as Team only can hold one value

Re: Include only certain values in script

vishsaggi — Wed, 24 Oct 2018 14:38:21 GMT

Can you explain a little more what you mean by repeats 8 more times, but you are saying in the end of the script you have a where condition?

Re: Include only certain values in script

neelamsaroha157 — Wed, 24 Oct 2018 14:41:18 GMT

I think another approach could be use of 'Match' function -

Where Match(team, 'ABC','DEF', you can add more values)

Or you can create a variable with Set vTeamVar = your values and use this variable in match function -

Where Match(team, $(vTeamvar))

Re: Include only certain values in script

evansabres — Wed, 24 Oct 2018 14:53:21 GMT

Thank you

Re: Include only certain values in script

evansabres — Wed, 24 Oct 2018 14:53:55 GMT

Apologies the question wasn't posed better, but was able to receive help. Thank you for your help