Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
Concatenate view 1 with 2
"Daily" AS "OrderType",
rest of your fields...
FROM Daily Orders View
"Monthly" AS "OrderType",
FROM Monthly Orders View
This way all your order facts are sourced from one table.
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?
'Monthly' AS "OrderType", should do it in your data load.