Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use the expression:
Substringcount(concat(Indicators,'|'),'A')
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.
Also, check out the following link, there are some nice examples:http://community.qlik.com/docs/DOC-5404