I am trying to create a statement with a list of values to choose from, something like 'in' statement in qlik ( charts script)
Exemplary, if we have a list of values {a,b,c,d,e,f}, this is what i would like to acheive:
if Field in 'a*','b*' then 'Group1'
Obviously when trying : = if(Field like 'a*' or 'b*'), Group1 , query takes only values with 'a*' . Of course one could end up making 6 nested if statement, but this is the worst-case scenario due to long loading of charts.
