topic Re: Dimension/Expression with multiple conditionals in QlikView

Dimension/Expression with multiple conditionals

AndreFrencl — Tue, 28 Dec 2021 12:29:26 GMT

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:

Thanks!

André

basav — Tue, 28 Dec 2021 21:55:18 GMT

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

AndreFrencl — Fri, 31 Dec 2021 11:29:57 GMT

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.