Discussion board where members can get started with QlikView.
I'm new to Qlik View. I'm working on an exercise and I'm facing a problem which I'm not able to find a solution.
Here I have two tables Facts and Sales_Territory. (Shown as in the below Image)
I want to join the field EmployeeID(from table SalesTerritory) to the table Facts(As shown in the below Image).
I have used the following script for this.
Load * From
Load StartDate,EndDate,TerritoryID Resident SalesTerritory;
But this does not give the desired output. Can anyone help me, please...........
Stanly R Johns
hehe it's a little bit tricky.
This script will do it, you just have to understand it now. Tell me if you miss something:
Territoy_ID&'/'&StartDate&'/'&EndDate as Territory_From_To,
(ooxml, embedded labels, table is Territory);
Territoy_ID&'/'&"Order Date" as Territory_Date,
Territoy_ID as Territoy_ID_Temp,
(ooxml, embedded labels, table is Fact);
Territoy_ID as Territoy_ID_Temp
Territoy_ID_Temp&'/'&[Order Date] as Territory_Date,
Territoy_ID_Temp&'/'&StartDate&'/'&EndDate as Territory_From_To
Drop table Temp;
View solution in original post
Thank you so much for your reply.
Your script worked perfectly and I got the solution for the problem. This is my very first post on Qlik Community and I got the correct answer in the first reply itself. I'm so happy.