Urgently Needed....Expression in Pivot Table

Anonymous — Sun, 17 Aug 2014 09:43:44 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')

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

Now what I want, my new daily transaction shuold start with the Closing Balance because if some body taking a leave then it will be deducted from the Accumulated Leave Balance.

I am new to Qlikview, so do not know which function I should use at expression level or script level to achieve this in Qlikview.

Need your help guys.

Regards,

Balraj

topic Urgently Needed....Expression in Pivot Table in QlikView

Urgently Needed....Expression in Pivot Table