Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
sagarkharpude
Creator III
Creator 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

Labels (1)
0 Replies