Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
AndreFrencl
Contributor III
Contributor III

Dimension/Expression with multiple conditionals

Hey, guys!

I have a problem !

I create a sheet with $table and $field. Every $field should be a dimension, by choice.

I create another list, with possible expression. 

 

When i filter one value, works fine. When i filter two or more values, show everything.

How filter only i choose? I use match function, but not works.

Pics:

Capturar1.PNGCapturar2.PNG

 

Thanks!

 

André

Labels (2)
1 Solution

Accepted Solutions
AndreFrencl
Contributor III
Contributor III
Author

i found the solution using the formula in conditional dimension and expression:

=GetSelectedCount($Field)>0 and SubStringCount( GetFieldSelections($Field), 'MonthName_CUP')>=1

 

atention:

- substringcount works when the field dont be the same characters , like:

       - BEST

       - BEST_DESCR

in this case, rename the BEST FIELD to BEST_MAIN , else the function bring the both fields.

 

 

View solution in original post

2 Replies
basav
Creator
Creator

To what I understood, you have list of dimensions and Expressions, you are trying to build a report based on selection of these. 

I am not sure how you can achieve this with Match function.

Please give a read in the below articles, this should help 

https://subscription.packtpub.com/book/big-data-and-business-intelligence/9781782179733/1/ch01lvl1se...

 

AndreFrencl
Contributor III
Contributor III
Author

i found the solution using the formula in conditional dimension and expression:

=GetSelectedCount($Field)>0 and SubStringCount( GetFieldSelections($Field), 'MonthName_CUP')>=1

 

atention:

- substringcount works when the field dont be the same characters , like:

       - BEST

       - BEST_DESCR

in this case, rename the BEST FIELD to BEST_MAIN , else the function bring the both fields.