Sum of SAL based on date

[qlikviewwizard]

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.

P

[qlikviewwizard]

Any help please.

[#3]

I cannot  see the expected report that you required.

[jagan · Accepted solution]

Hi,

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

Regards,

Jagan.