I have a group of store locations.. I need to identify as either "Joint Venture" or "Enterprise" in my charts.
I have a custom dimension with the following expression:
=IF(StoreName = 'Derm 1' or
'Derm 3' or 'Derm 4', 'Enterprise', 'Joint Venture')
But it only picks up 'Derm 1' as Enterprise and not the other two. What am I missing?
Thanks in advance.
you have missed to call that field name for multiple times like below
basic if condition :
=IF(StoreName = 'Derm 1' or StoreName = 'Derm 3' or StoreName = 'Derm 2' ,'Enterprise', 'Joint Venture')
simplified if condition
if(match( StoreName , 'Derm 1' ,'Derm 3','Derm 2') ,'Enterprise', 'Joint Venture')
and if you wish to apply wildcard then try to use like below
example, if u like to search all StoreName starting with Derm* then u can define like below,
If(WildMatch(StoreName , 'Derm*'),'Enterprise', 'Joint Venture')
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.