Sum of SAL based on date

qlikviewwizard — Wed, 13 May 2015 11:19:46 GMT

Hi Folks,

Kindly help my requirement as shown below:

I have the hierarchy Incharge1 > Incharge2 > Ename

If EndDt<StartDt then Ename SAL =0 and the same amount to be distribute to Incharge1 & Incharge2

If EndDt is NULL then SAL should distribute to Ename

My report should show like the below:

please help me.

Source Data:

EMPNO	Ename	Incharge1	Incharge2	SAL	StartDt	EndDt
1	Ename1	Ename5	Ename9	1000	12-May-15	11-May-15
2	Ename2	Ename5	Ename9	2000	11-May-15	3-May-15
3	Ename3	Ename5	Ename9	3000	10-May-15
4	Ename4	Ename5	Ename9	1000	9-May-15
5	Ename5	Ename5		2000	8-May-15
6	Ename6	Ename5	Ename9	3000	7-May-15
7	Ename7	Ename10	Ename9	1000	12-May-15	10-May-15
8	Ename8	Ename10	Ename9	2000	11-May-15	3-May-15
9	Ename9	Ename10	Ename3	3000	10-May-15
10	Ename10			4000	7-May-15

SAL column is shown 1000+2000 ,.. is for better understanding.

Re: Sum of SAL based on date

qlikviewwizard — Thu, 14 May 2015 02:34:53 GMT

Any help please.

Thu, 14 May 2015 03:19:50 GMT

I cannot see the expected report that you required.

jagan — Thu, 14 May 2015 03:48:11 GMT

Hi,

You can manage this easily with Pivot table. Please find attached file for solution.

Regards,

Jagan.