Discussion board where members can get started with Qlik Sense.
I am trying to use the IF and Match statements together to create the below expression:
so that if the selected items match the requirement, the button will be colored Blue (RGB code above).
I keep getting an error and any help rendered will be appreciated.
Go to Solution.
Try this may be
If(WildMatch(GetFieldSelections(Product),'*Explorer*', '*Durango*', '*Highlander*', '*Pathfinder*'), RGB(5,66,117))
Extremely well done there my friend.
Do you mind explaining why we had to use the WildMatch vs. Match?
Well, I was not sure if you are going to ever select one value in Product or can you select multiple values as well... if you are going to just select 1 value..... then you can use this
If(Match(GetFieldSelections(Product),'Explorer', 'Durango', 'Highlander', 'Pathfinder'), RGB(5,66,117))