topic Loading data from two databases with same table structures in QlikView

Loading data from two databases with same table structures

Qlik_Enthu — Wed, 14 Jun 2017 13:21:36 GMT

Dear All,

I need to create a dashboard taking data from two different databases but with same table structures (including same column names).

I have blindly loaded the two tables and qualified the columns and unqualified one key column to establish connection between two tables. But now I could not figure out how to aggregate and visualise the data from two tables.

If someone come across similar situation, kindly throw some light

TIA!

Re: Loading data from two databases with same table structures

m_woolf — Wed, 14 Jun 2017 13:28:08 GMT

Any reason not to concatenate the two tables?

If you need to know which table the data came from, you could do something like:

'Table1' as DataSource

Re: Loading data from two databases with same table structures

Qlik_Enthu — Wed, 14 Jun 2017 14:06:39 GMT

I know which data comes from which table. however I need to display total orders placed in both databases in my visualizations.

Re: Loading data from two databases with same table structures

Anonymous — Wed, 14 Jun 2017 14:40:32 GMT

If you concatenate the tables and add a column indicating which table the rows go to -

You can then easily do order counts by datasource using set analysis.

Something like count({<Datasource={'Table1'}>}OrderID) and count({<Datasource={'Table2'}>}OrderID)