Discussion Board for collaboration regarding Qlik DataMarket.
Hello:I am trying to use a calculated field from one table in another table.
I tried to use ApplyMap() by Mapping JobCode. It didnt work ... I might've not done it the right way. What is the correct way to do this?
Basically below is my sample table structure and the logic trying to use.
Please help. THANK YOU.
IF([JobCode] = '0','Yes',
IF([JobCode]='9' AND [ManagerLvl] = '8', 'Yes',
IF([JobCode]='9' AND [ManagerLvl] = '9', 'Yes',
IF([JobCode]='9' AND [ManagerLvl] = '10', 'Yes','No'))))) as "Mgr_Agr_Required"
Actives.xls (biff, embedded labels, table is Detail$);
IF(Mgr_Agr_Required='Yes' AND [Mgr_Agr_Dt] = IsNull(),'Non-Compliant','Compliant')) as "Compliance Status"
Agreements.xls (biff, embedded labels, table is Agreements$);
Go to Solution.
Try to something like this:
MAPPING LOAD EmployeeID AS MAP_MGR_AGR_REQUIRED_EmployeeID,
Mgr_Agr_Required AS MAP_MGR_AGR_REQUIRED_Mgr_Agr_Required
IF(ApplyMap('MAP_MGR_AGR_REQUIRED', EmployeeID, 'No')='Yes' AND [Mgr_Agr_Dt] = IsNull(),'Non-Compliant','Compliant')) as "Compliance Status"
Thank you Hector.This worked but not with "IsNull". I used Len(Trim(
Appreciate your time.
Yes Archana, you are right, is with Len() how it works... Nice to help you!