topic Re: Month Wise Values in QlikView

Month Wise Values

Anonymous — Wed, 20 Aug 2014 08:49:33 GMT

Hello All,

I am having a field say Total_CasualLeave which is static and predefined.

Now I have to show Day wise balance if he or she takes any CasualLeave.

Example:


Name	Date	Total_CasualLeave	CL TAKEN	Closing CL Balance
A	21st May	10	1	9
A	28th May	9	0	9
A	18th June	7	2	7

What is the solution and How I can solve it?

Regards,

Balraj

Re: Month Wise Values

MK_QSL — Wed, 20 Aug 2014 08:57:44 GMT

Provide some more information on your data model or tables...

10 - [CL TAKEN]

Re: Month Wise Values

Anonymous — Wed, 20 Aug 2014 09:03:52 GMT

Manish,

I am having a LeaveLedger table which is having static/Fix set of leave defined for a person.

In other table LeaveRequest with fields like(LeaveDate, LeaveCode, NoOfLeaveDays etc), which keep the track if any person have taken any leave.

Let me know if you required any other info?

Regards,

Balraj

Re: Month Wise Values

Anonymous — Wed, 20 Aug 2014 09:08:02 GMT

Here is table details:

LOAD PAYCODE,

L01_ADD as Total_CL(Allotted for a Year),

L02_ADD as Total_SL,

L03_ADD as Total_EL,

LYEAR

from LeaveLedger;

Another table is:

LOAD PAYCODE,

//request_date,

leave_from,

leave_to,

leavecode as LEAVECODE,

leavedays

from LeaveRequest;

With these info I need to drive above result.

Pls suggest.

Re: Month Wise Values

Wed, 20 Aug 2014 09:28:03 GMT

HI Balraj,

You can resolve this by fallowing code,

Load Name ,

Date,

Total_CasualLeave as [Total casual Leaves],

Total_CasualLeave - previous(Total_CasualLeave) as [Leaves Taken] ,

Total_CasualLeave - (Total_CasualLeave - previous(Total_CasualLeave)) as Leave balance

from Table Orderby Date ;

I hope it helps...........

Re: Month Wise Values

Anonymous — Wed, 20 Aug 2014 09:35:34 GMT

Koti,

Thanks for your reply.

But Total_CasualLeave is a fix value field for each employee, it is not changing by date.