Two separate tables with one filter

fhana — Mon, 31 Mar 2025 15:48:35 GMT

I have two unassociated tables, Opportunity and Lead.
Both tables have fields like LeadSource, LeadSourceDetails, Owner, AssumedTerritory

I would like to have filters on the sheet that will filter both tables by separate fields so that the tables are not associated and return results based on the applied filter.

The outcome should be KPI numbers that are counted in each table based on the applied filter.

I tried
something like this

[tmpLeadSourceTable]: Load Distinct LeadSource_lead as LeadSource Resident Lead; Concatenate([tmpLeadSourceTable]) Load Distinct LeadSource_opp as LeadSource Resident Opportunity; [LeadSourceTable]: LOAD [LeadSource] ,[LeadSource] as LeadSource_opp ,[LeadSource] as LeadSource_lead; LOAD Distinct [LeadSource] Resident tmpLeadSourceTable; drop table tmpLeadSourceTable;

and this works but when I try to add another definition for next filed like this it show circular dependency.

How can I achieve something like this?

Re: Two separate tables with one filter

Chanty4u — Mon, 31 Mar 2025 18:32:04 GMT

You can use link table concept

Pls have a look

https://community.qlik.com/t5/QlikView-App-Dev/what-is-link-table-how-it-works-and-its-usage/td-p/1039484

topic Re: Two separate tables with one filter in App Development

Two separate tables with one filter

Re: Two separate tables with one filter