If statement with multiple values selection

Mt3 — Mon, 31 Jan 2022 10:57:32 GMT

Hi,

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.

Re: If statement with multiple values selection

MarcoWedel — Mon, 31 Jan 2022 11:03:50 GMT

If(WildMatch(Field, 'a*', 'b*'), 'Group1')

topic Re: If statement with multiple values selection in App Development

If statement with multiple values selection

Re: If statement with multiple values selection