Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
tobiasaechter
Contributor III
Contributor III

show table box conditionally with match & getfieldselection

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

Labels (2)
2 Solutions

Accepted Solutions
MayilVahanan

HI 

Try like below in "conditional"

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

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

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

3 Replies
MayilVahanan

HI 

Try like below in "conditional"

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

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

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Contributor III
Contributor III
Author

thanks, both options work well for me 🙂