Use if with multiple members of a variable

[juandevqlik]

Hi,

I create one variable called name with values 'green', 'red', 'blue'.

I create a filter which contains this dimension "name" and show 3 values, all correct here.

I have other variables of amount called: 'greenamount', 'redamount', 'blueamount', 'greenandredamount' and all the combinations ...

Then i want to create a table in which the column depends on the filter selection. So for example:

if (name = green, 'greenamount'), this works perfect but when im trying to choose 2 values in the filter the logic doesnt works. So if the user, clicks on 2 options of the filter: 'red' and 'blue', i would like to do something like if(name = 'green and name='blue', 'greenandblueamount')

Is this posible at qlik sense? 

Thanks for the replies 

[vinieme12 · Accepted solution]

change to below

=if(substringcount(GetFieldSelections(name),'red') and substringcount(GetFieldSelections(name),'blue'),'greenandblueamount')

[juandevqlik]

works perfect, thanks for your reply very usefull 🙂