Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using Conditional to show a expression

Hi,

I have a table with many expressions (columns). I want to show some of the columns using the check box "Conditional".

For example, I have a field called 'indicators' with de values A, B, C, D.

In the table, I can write the conditions: Indicators='A' , Indicators='B', Indicators='C' and Indicators='D' for the expressions to show the columns and it works correctly when only one 'Indicator' is chosen, but when several 'Indicators' are chosen it doesn't show any of the selected columns instead of show all selected columns.

How to solve it?

Thanks


1 Solution

Accepted Solutions
simenkg
Specialist
Specialist

Use the expression:

Substringcount(concat(Indicators,'|'),'A')

View solution in original post

3 Replies
simenkg
Specialist
Specialist

Use the expression:

Substringcount(concat(Indicators,'|'),'A')

manojkulkarni
Partner - Specialist II
Partner - Specialist II

As per understanding, you would like to show respective indicator's when each of them selected.

If user selected multiple, then you would like to show all of them. Am i Correct ?

In that case, use indicators in dimension with condition.

awhitfield
Partner - Champion
Partner - Champion

Also, check out the following link, there are some nice examples:http://community.qlik.com/docs/DOC-5404