show table box conditionally with match & getfieldselection

[tobiasaechter]

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 · Accepted solution]

HI 

Try like below in "conditional"

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

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

[rwunderlich · Accepted solution]

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')) 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[tobiasaechter]

thanks, both options work well for me 🙂