Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

sagarkharpude
Contributor III

Set Status Issue

Hi All,

I have difficulty in following logic. If employee having any 1 status as “Skills Approved by Manager” out  of below (Case3) skill status then I want to set the status as “Skills Approved by Manager”.

If   employee having any 1 status as “Skills Submitted for Approval” out  of below (Case 2) skill status then I want to set the status as “Skills Approved by Manager”.

Otherwise “ Save As Draft”.

                                             


 


 

 

Skill Status


 

 

Set Skill Status as below


 

 

Case 1


 

 

Skills Approved by Manager


 

 

Skills Approved by Manager


 

 

Skills Submitted for Approval


 

 

Save As Draft


 

 


 

 


 

 


 

 

Case 2


 

 

Skills Submitted for Approval


 

 

Skills Submitted for Approval


 

 


 

 

Save As Draft


 

 


 

 


 

 


 

 

Case 3


 

 

Save As Draft


 

 

Save As Draft


 

 


 

 


 

 


 

Examples:-                                                                                          

Case 1
EmpIdSkill StatusLastUpdatedDateExpected Result
1Save As Draft10/07/2014Skills Approved by Manager
1Save As Draft
1Skills Approved by
  Manager
05/07/2014
1Skills Submitted for
  Approval
05/07/2014
Case 2
EmpIdSkillStatusLastUpdatedDateExpected Result
2Save As Draft10/07/2014Skills Submitted for
  Approval
2Save As Draft
2Skills Submitted for
  Approval
05/07/2014
Case 3
EmpIdSkillStatusLastUpdatedDateExpected Result
3Save As Draft10/07/2014Save As Draft
3Save As Draft

Please suggest me if you have any logic.

    

Thanks & Regards

  Sagar Kharpude

Community Browser