Set Status Issue

sagarkharpude — Tue, 16 Sep 2014 05:29:00 GMT

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	Skills Submitted for Approval

Case 3	Save As Draft	Save As Draft

Examples:-

Case 1
EmpId	Skill Status	LastUpdatedDate	Expected Result
1	Save As Draft	10/07/2014	Skills Approved by Manager
1	Save As Draft
1	Skills Approved by Manager	05/07/2014
1	Skills Submitted for Approval	05/07/2014
Case 2
EmpId	SkillStatus	LastUpdatedDate	Expected Result
2	Save As Draft	10/07/2014	Skills Submitted for Approval
2	Save As Draft
2	Skills Submitted for Approval	05/07/2014
Case 3
EmpId	SkillStatus	LastUpdatedDate	Expected Result
3	Save As Draft	10/07/2014	Save As Draft
3	Save As Draft		Save As Draft

Please suggest me if you have any logic.

Thanks & Regards

Sagar Kharpude

topic Set Status Issue in QlikView

Set Status Issue