topic Re: Conditional Show Dimensions in QlikView

Conditional Show Dimensions

jyothish8807 — Mon, 01 Jun 2015 13:29:04 GMT

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!

Re: Conditional Show Dimensions

avinashelite — Mon, 01 Jun 2015 13:34:57 GMT

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.

Re: Conditional Show Dimensions

jyothish8807 — Mon, 01 Jun 2015 13:42:39 GMT

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

Re: Conditional Show Dimensions

b_garside — Mon, 01 Jun 2015 13:51:30 GMT

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')

Re: Conditional Show Dimensions

jyothish8807 — Mon, 01 Jun 2015 13:52:44 GMT

Hi Brian,

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

Regards

Re: Conditional Show Dimensions

nagaiank — Mon, 01 Jun 2015 13:56:27 GMT

Try using the expression

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

Re: Conditional Show Dimensions

jyothish8807 — Mon, 01 Jun 2015 14:05:01 GMT

Awesome, this worked. Nice trick

Regards