Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional dimensions - similar names in listbox

Hello developers,

could anybody please give me any advice about my problem? Maybe someone 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 theese similar names in list box with dimensions? Now is this conditional expression in use:

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

Thank you!

1 Solution

Accepted Solutions
Not applicable
Author

Hi mirek,

PFA,  Hope Needful has been done.

Regards,

Nirmal.

View solution in original post

2 Replies
Not applicable
Author

Hi mirek,

PFA,  Hope Needful has been done.

Regards,

Nirmal.

Not applicable
Author

Hi nirmal.j,

thank you for your reply. Your solution is one of possible solutions, but then appearance of dimensions is changed. I figured this solution:

Instead this:

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

This:

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

Have a nice day!