topic Re: show table box conditionally with match & getfieldselection in QlikView

show table box conditionally with match & getfieldselection

tobiasaechter — Wed, 01 Sep 2021 12:49:12 GMT

Hi,

I am trying to show a table box conditionally, depending on a field selection.

I have a field called business which has a couple of field values, lets say: A, B, C, X, Y, Z

I would like to show one table now when A, B or C are selected or another table when X, Y or Z are selected.

my initial idea was the following: if(not match(business, 'X','Y','Z'), GetFieldSelections(business) -> table 1 for A, B, C should show up.

unfortunately this does not work as expected and when selecting X, Y or Z I can still see the same table as when selecting A, B or C.

Can anyone help me with what I am missing here? Thanks

MayilVahanan — Wed, 01 Sep 2021 15:00:19 GMT

Try like below in "conditional"

1st chart: match(business, 'X','Y','Z')

2nd Chart: not match(business, 'X','Y','Z')

rwunderlich — Wed, 01 Sep 2021 15:04:45 GMT

Here's the approach I would take:

=GetSelectedCount(business) // Test if something is selected in business

=max(match(business, 'A', 'B', 'C')) // Test business field with list

So my calculation condition would be:

=GetSelectedCount(business) and max(match(business, 'A', 'B', 'C'))

tobiasaechter — Thu, 02 Sep 2021 07:44:30 GMT

thanks, both options work well for me 🙂