
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Switch table and filter
I have a filter and a table A and a table B.
I am implementing a Switch dropdown to switch the table to A or B.
Table A and Table B are quoted from different DB tables.
・Filter condition: Table X in DB
・Table A: Table A in DB
・Table B: Table B in DB
Although they are related, Table A and Table B contain RowNo() as RowIDA and RowNo() as RowIDB to count the number of rows respectively, so Table A and Table B cannot be put in the same table.
Therefore, even if you narrow down the conditions with a filter, you can only narrow down the table A, and there is no table B.
Is there a better way?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Louise
If this is working for you - then I would say that it is ok for your use case. If you would like to explain a bit more of why you are doing this, it may be helpful to discover if a better way does exist.
Are you familiar with alternate states?
As you can setup individual charts and filters to link to one another without effecting one another.
Take a look at this and let me know if this helps: https://youtu.be/IKnd1wgNPnc
Mike Tarallo
Qlik

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much! I could make it!
But, I use the if statement on filter, so I can't transfer the data from sheet to sheet.
How should I transfer data from sheet to sheet?
