how to compare previous month with current month using apply map

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

we are having two tables .both the tables have ID in common we are linking through it.if particular ID is not found we are displaying it as "Not Available".if ID is not available it should display the previous Month department only for those which is "Not Available".

using applymap we got Not Available .

and the below code is for those who are not available for them we are trying to get the department from previous month table.

Map_Emp:

Mapping Load

" ID" ,

"Department"

Resident table1;

Missing_ID:

load

"user id" as Missing_ID,

Month_Year as [Month-Year],

Dept,

ApplyMap('Map_Emp',"user id") as Missing_Department

Resident table2;

Re: how to compare previous month with current month using apply map

sunny_talwar — Thu, 22 Sep 2016 17:11:18 GMT

What is the exact issue you are running into?

topic how to compare previous month with current month using apply map in QlikView

how to compare previous month with current month using apply map

Re: how to compare previous month with current month using apply map