Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Different data source

I have 2 different sources for dashboard. When I click the button dashboard should consider 2nd data source else 1st data source.

Please help

3 Replies
rahulpawarb
Specialist III
Specialist III

Hello Narendra,

Please refer attached sample application.

Hope this will be helpful.

Regards!

Rahul

Anil_Babu_Samineni

Does data source has Same Structure or different Names. Can you elaborate more please

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Peter_Cammaert
Partner - Champion III
Partner - Champion III

You can use a technique called "versioning" to handle this. Load everything you need from both sources, and mark all rows with a flag or indicator that identifies the data source. Also add this indicator to all composite keys.

Add a listbox to your dashboard with "Always one selected" enabled. You can create buttons to make selections in this listbox if you want to.

Later on, you can define common dimension tables that should be loaded only once and whopse rows applie to both "versions".