Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
bwisenosimenkg
Valued Contributor

Re: Using Conditional to show a expression

Use the expression:

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

3 Replies
bwisenosimenkg
Valued Contributor

Re: Using Conditional to show a expression

Use the expression:

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

manojkulkarni
Valued Contributor II

Re: Using Conditional to show a expression

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
Esteemed Contributor

Re: Using Conditional to show a expression

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

Community Browser