Dimension Selection Check

[jorgie]

Hi to all!

Not a catchy title but there is my issue.

I have the following variable which includes a range of field names.

I try to make a expression that checks if the row I have in pivot table is included in the variable.

I use the following expressions

If(Match(GetObjectField(Dimensionality()), SubField('$(vCustomerDimensions)',', ')) > 0, 1, 0)

and

If(WildMatch($(vCustomerDimensions), '*' & GetObjectField(Dimensionality()) & '*'), 1, 0)

but the results I get is 0. The three dimensions are included in the variable

Thank you in advance for you time and help

jT

[henrikalmen]

Try this:

If(WildMatch('$(vCustomerDimensions)', chr(39)&'*' & GetObjectField(Dimensionality()) & '*'&chr(39)), 1, 0)

[jorgie]

thanks for replying!

Unfortunately all zer0s.

I tried also 

If(WildMatch($(vCustomerDimensions), chr(39)&'*' & GetObjectField(Dimensionality()) & '*'&chr(39)), 1, 0)

cause vCustomerDimensions is field but still zer0s as result....

[henrikalmen]

You need apostrophes surrounding the expanded variable. I don't know, perhaps expand getobjectfield as well:

WildMatch('$(vCustomerDimensions)', '*$(=GetObjectField(Dimensionality()))*')

(You don't need to wrap your wildmatch in an if-statement, it will return 0 or 1 anyways. Assuming GetObjectField(Dimensionality())) works in this context, perhaps it doesn't...)

[jorgie · Accepted solution]

thank you very much!

the solution is combined a previous code i mention with your apostrophes

Meaning 

WildMatch('$(vCustomerDimensions)', '*' & GetObjectField(Dimensionality())&'*' )

need some optimizations for the necessary calculations, but still is the expected result

thanks for your time and effort