topic Using Multiple Table views - Qlik sense in App Development

Using Multiple Table views - Qlik sense

joeybird — Thu, 12 Nov 2015 09:40:19 GMT

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

ogster1974 — Thu, 12 Nov 2015 10:31:52 GMT

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 — Thu, 12 Nov 2015 12:04:34 GMT

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 — Thu, 12 Nov 2015 13:32:05 GMT

Yes

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