Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

vaisgaard
New Contributor

Inspiration on data loading into a fact table in Qlik Sense

Hi fellow data geeks,

I need some inspiration on how to load data into a fact table from multiple sources. I know how to do this in Oracle, but I would like to start using Qlik Sense to do this instead.

Scenario: I have multiple data sources which contains the data I need:

Budgets: (Excel sheet)

year_monthchannelbudget
201706online5000
201706direct sales2300
201706tele sales1000
201706shops6500

Online sales: (MSSQL database) aggregated

year_monthno_of_sales
2017064521
2017055874
2017045586
2017035412

Direct sales, tele sales and shop sales: (Oracle database) aggregated:

year_monthchannelno_of_sales
201706direct sales2458
201706tele sales857
201706shop sales7811
201705direct sales3157
201705tele sales1247
201705shop sales7436

So how would I put the above into a fact table using Qlik Sense only?

1 Reply
Not applicable

Re: Inspiration on data loading into a fact table in Qlik Sense

Hello,

Is there a link between the 3 data sources ?

For example Online sales: (MSSQL database) is linked to Direct sales, tele sales and shop sales: (Oracle database) using no_of_sales ?



if there is no link between the 3 tables do the following:

Tables:

Load

* ,

'Budget' as Flag

from Budget.xlsx

concatenate(Tables)

Load

*,

'Online sales' as Flag

from Online sales: (MSSQL database)


concatenate(Tables)

Load

*,

'Oracle database' as Flag

from Direct sales, tele sales and shop sales: (Oracle database)



In the above case, we concatenated the 3 tables into one table in qlik sense.

If there is a link between MSSQL and Oracle :


MSSSQL:

Load

*

from Online sales: (MSSQL database)


left join

Load

*

from Direct sales, tele sales and shop sales: (Oracle database)


Tables:

Tables:

Load

* ,

'Budget' as Flag

from Budget.xlsx;


concatenate(tables)

Load *,

'NotBudget' as Flag

resident MSSSQL;