Conditional Show Dimensions

[jyothish8807]

Hello,

could you please give me any advice about my problem? Maybe you already met this.

I have dimensions in listbox which are similar. That mean that some of them contains same words.

Customer

Customer Phone

Customer Country

When "Customer phone" is selected, in table "Customer" will appear as well. Is there any chance to use these similar names in list box with dimensions? Now is this conditional expression in use:

=SubStringCount(Concat(Fields, '|'), 'Customer')

Thank you!

[avinashelite]

Hi Jyothish,

Do you want to build a dimension out of  it??

try using WILDMATCH and math the similar words and give a proper dimension name I think that will do you requirement i guess.

[jyothish8807]

Tried with WILDMATCH but it didnt work. I am enabling and disabling the dimensions dynamically.

So now when i select Customer Phone, Customer is also getting enabled.

Regards

KC

[b_garside]

Its picking up Customer in each dim field since they all have that in common. You will need to explicitly spell out each one like the example below.  Hope this helps. The other thing you can try is assign an Index Id column for each Dim and use that instead.

=SubStringCount(Concat(Fields, '|'), 'Customer')

=SubStringCount(Concat(Fields, '|'), 'Customer Phone')

=SubStringCount(Concat(Fields, '|'), 'Customer Country')

[jyothish8807]

Hi Brian,

I have already done this. Still it is picking Customer.

Regards

KC

[nagaiank · Accepted solution]

Try using the expression

SubStringCount(Concat('~'&Fields&'~', '|'), '~Customer~')

[jyothish8807]

Awesome, this worked. Nice trick

Regards

KC