ValueList and Dimension Match

[StacyCui]

Hi, I met an issue. I want to use bar chart to tracking CY & PY OR .I marked the customer a flag according to the OR. and then I created a custom dimension by ValueList function:

v_FY23_List:ValueList('FY22 OR','FY23_Sleeping','FY23_Lost','FY23_Signif Drop','FY23_Normal','FY23_Signif Grow','FY23_Woken Up','FY23_New with OR','FY23_New w/o OR','FY23 OR')

The "Flag" : 'FY23_Sleeping','FY23_Lost','FY23_Signif Drop','FY23_Normal','FY23_Signif Grow','FY23_Woken Up','FY23_New with OR','FY23_New w/o OR' fields.

When I select a customer whose flag is FY23_Sleeping. I write a expression: pick(Match(Flag,$(v_FY23_List)),CY OR-PY OR,0) , It shows 0. It seems Flag dimension could not match variable. Ideally, When I select a customer, only show FY22 OR/ its flag/ FY23 OR three dimensions. In other words, I want to mapping flag and valuelist.  How to solve it?

[henrikalmen]

I'm not sure if this is your solution, but in the match function you need to have the valuelist first and after that your search criteria, like this: pick(Match($(v_FY23_List), Flag),'CY OR-PY OR',0)

Also note that I enclosed 'CY OR-PY OR' in single quotes so that it becomes a string, but I'm not sure if that is what you want. Right now this expression gives the result string 'CY OR-PY OR' if flag='FY22 OR' and the result is 0 if flag='FY23_Lost' and in all other cases it returns null().