topic Need Immediate help on following KPI in QlikView

Need Immediate help on following KPI

Anonymous — Mon, 18 Aug 2014 08:14:11 GMT

Dear All,

I am having following fields: EmpName, LeaveMonth, Total_CasualLeave, Total_SickLeave(Predefined), LeaveCode, LeaveDays etc.

Now I have to generate a Report(Need_To_Achieve Sample is attached) which will show a leave balance of a employee on daily basis.

I have calculated following fields:

Accumulated CasualLeave= sum(Total_CasualLeave), same for rest.

CL Accrued= if(LeaveCode='CL', sum(LeaveDays), '0'), same for rest

Closing CL Balance= sum(Total_CasualLeave) - if(LeaveCode='CL', sum(LeaveDays), '0'), same for rest

After start of leave balance of a employee, I want next time it should be replace by his/her Closing balance on daily basis.

Example:

EmpName, Calender, Acc. CL Balance, Accu SL Balance, CL Accrued, SL Accrued, Closing CL Balance, Closing SL Balance

aaa 2th Aug 2014 10 10 2 0 8 10

aaa 11th Aug 2014 8 10 0 2 8 8

aaa 18th Aug 2014 8 8 1 0 7 8 and so on....

Need your help guys.

Regards,

Balraj

Re: Need Immediate help on following KPI

Gysbert_Wassenaar — Mon, 18 Aug 2014 08:46:46 GMT

See attached qvw.

Re: Need Immediate help on following KPI

Anonymous — Mon, 18 Aug 2014 09:05:01 GMT

Gysbert,

Thanks for your reply.

But these CL Accrued, SL Accrued, Closing CL Balance, Closing SL Balance etc all are having expression which are getting calculated from multiple fields and tables at the expression level on the chart object.

Calculating them at script level is not working as I am calculating single value from multiple fields.

Total_CasualLeave, Total_SickLeave(Predefined) in Tab1 and LeaveCode, LeaveDays in Tab2.

Is their any solution which I can use at expression level or would require your help to do it at script level.

Pls suggest.

Regards,

Balraj

Re: Need Immediate help on following KPI

Gysbert_Wassenaar — Mon, 18 Aug 2014 09:12:32 GMT

Maybe you can use the above() function, or one of its siblings before(), after(), below().

Re: Need Immediate help on following KPI

Anonymous — Mon, 18 Aug 2014 09:17:46 GMT

Could you suggest me how I can use above() function here and with which expression??

Accumulated CasualLeave= sum(Total_CasualLeave), same for rest.

CL Accrued= if(LeaveCode='CL', sum(LeaveDays), '0'), same for rest

Closing CL Balance= sum(Total_CasualLeave) - if(LeaveCode='CL', sum(LeaveDays), '0'), same for rest

After 1st transaction of a Faculty my closing balance of that transaction would be Accumulated Balance of next transaction.

I hope you have clear understanding after gone through the Excel which I need to achieve.

Regards,

Balraj