Discussion board where members can get started with Qlik Sense.
I need combine the two table and need to display the data based on sales person ,Please find the table details below
EmployeeID as EMPID%,
"Year",----->Contain only 2014 year
Load * Resident 2014;
EmployeeID as [EMPID%],
"Year",---->2015 as year
Quater ,---->Contain Q1,Q2,Q3,Q4
Drop Table 2014;
in 2014 table it is having sales Person name related to the EMPID and i need the same in 2015 to display the sales person name,
Kindly let me know how we can achieve.
Mapping Load EmployeeID,
ApplyMap('MapTable',EmployeeID) as SalesPerson
View solution in original post
Thank You So much omar,It is working Fine
Need to Know,Whether is there any other way to do this.