Qlik Community

Qlik Sense App Development

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

joeybird
Contributor II

Using Multiple Table views - Qlik sense

Hiya

I have two views, which I wish to use within the qlik sense environment...

one is DailyOrders, which is a view which brings back....Daily orders of every customer...and OrderDate are 01/01/2014, 02/01/2014 and so on

Other is MonthlyOrders which is a view which brings back....weekly orders of every customer ... and OrderDate are 01/01/2014, 01/02/2014 and so on

these two tables have exactly the same fields names...

my current app and its charts contained within just looks at the MonthlyOrders,

I wish to now join the DailyOrders

I understand making a fact table will be best... but how

please advise

3 Replies
ogster1974
Honored Contributor II

Re: Using Multiple Table views - Qlik sense

Concatenate view 1 with 2

Orders:

LOAD

    "Daily" AS "OrderType",

rest of your fields...

.

.

FROM Daily Orders View

CONCATENATE

LOAD

    "Monthly" AS "OrderType",

rest of your fields...

.

.

FROM Monthly Orders View

This way all your order facts are sourced from one table.

joeybird
Contributor II

Re: Using Multiple Table views - Qlik sense

Hiya

the issue I have is the views are from a SQL server

adding "Monthly" AS "OrderType",


I get an error... as you would is there a way of adding these fields manually in Qlik sense in without adding the to the SQL database?

Please help

ogster1974
Honored Contributor II

Re: Using Multiple Table views - Qlik sense

Yes

'Monthly' AS "OrderType", should do it in your data load.

Community Browser