Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Ant_19
Contributor II
Contributor II

Show/Hide tables in Container

good day everybody,

I created sheet with 2 different tables with essential data, each table has relevant data based on the filter panel.

let's call them table A with Field_A and Table B with Field_B

Now, to get all the details, I created a container with 3 tables:

- a generic table, that should be visible if none of the fields in previous data are selected (Table A and Table B are hidden) this works

- table 1, which should be visible only if the data in Table A is selected (then the generic table and Table B are hidden)

- Table 2, which should be visible only if the data in Table B is selected (then the generic table and Table A are Hidden)

in the forum I found the formula Getselectedcount. Using this formula: 

GetSelectedCount("Field_A")=0 and GetSelectedCount("Field_B")=0 and GetSelectedCount("Field_generic")=0

in theory I do not any fields selected, so the generic table is visible.

then, I tried to modify above formula to show the table 1 S:

GetSelectedCount("Field_A")>0 and GetSelectedCount("Field_B")=0 and GetSelectedCount("Field_generic")=0

but when I select the Field_A in Table A the generic table still visible, but with no item selected, Table 1 still hidden

thanks in advantage for your help.

Labels (1)
0 Replies