Sub Cells in cell in Pivot or Straight Table

[#1]

Hi,

I have two tables, Table1 and Table2 as Follows,

Table1:

ID	PNAME	MANAGER	REQUIRED
1	PR1	RAM	3
2	PR2	RAVI	4
3	PR3	RAJ	2.5
4	PR4	SEKHAR	5
5	PR5	MOHAN	6

Table2:

ID	PNAME	MANAGER	RESOURCE NAME	PROVIDED
1	PR1	RAM	FEDRICK	1
1	PR1	RAM	AJAY	1.5
2	PR2	RAVI	JOHN	2
2	PR2	RAVI	ALLEN	1.5
3	PR3	RAJ	RAMU	1
3	PR3	RAJ	SELVA	1
4	PR4	SEKHAR	RAMANA	1.5
4	PR4	SEKHAR	BHASKAR	2.5
5	PR5	MOHAN	GANESH	2.6
5	PR5	MOHAN	PRAVEEN	3.4

My Requirement is as Follows,

DIFF=PROVIDED-REQUIRED (For example, Manager RAM has two Resources FEDRICK and AJAY,  For 'FEDRICK' PROVIDED value is 1 and for 'AJAY' is 1.5. I want to sum those values(2.5) and subtract them from REQUIRED Value(3), then DIFF is 0.5)

Output Required:

ID	PNAME	MANAGER	RESOURCE NAME	DIFF(PROVIDED-REQUIRED)
1	PR1	RAM	FEDRICK	0.5
			AJAY
2	PR2	RAVI	JOHN	0.5
			ALLEN
3	PR3	RAJ	RAMU	0
			SELVA
4	PR4	SEKHAR	RAMANA	1
			BHASKAR
5	PR5	MOHAN	GANESH	0
			PRAVEEN

I'm new to QLIKVIEW and i tried this my level best, But i didn't get exact output.

Experts Please Can anyone have a look into this and give me suggestion.

I'm attached my sample QVW also, Please provide solution for this.

Thanks,

Chiru

[Alejandro_Hernández]

see attached

[#3]

Hi Hernandez,

Thanks for your Support, But my Requirement is like

ID	PNAME	MANAGER	RESOURCE NAME	REQUIRED	PROVIDED	DIFF
1	PR1	RAM	FEDRICK	3	2.5	0.5
			AJAY
2	PR2	RAVI	JOHN	4	3.5	0.5
			ALLEN
3	PR3	RAJ	RAMU	2	2	0
			SELVA
4	PR4	SEKHAR	RAMANA	5	4	1
			BHASKAR
5	PR5	MOHAN	GANESH	6	6	0
			PRAVEEN

Please provide some suggestion.

Thanks,

Chiru

[ashwanin]

Hi Chiru,

Is it necessary to add the Resource name in the field ?

I have attached w/o resource data.

rgds

Ashwani

[sparur]

Hi Please see in my attach

[#6]

HI Kumar,

Yes, there should be 'Resource Name' necessarily.

Thanks,

Vamsi

[Gysbert_Wassenaar]

Use excel. This is not possible in Qlikview.

[sparur]

Why is not possible? I have attached example with very similar view...

[Alejandro_Hernández]

You mean you need those 2 new expressions or you need to merge cells for each resource?

[#10]

Hi Hernandez,

My requirement is ID, PNAME, MANAGER should be one and RESOURCE NAME should merge, REQUIRED value should be one (Like 3), PROVIDED is sum of values based on MANAGER (Like 1+1.5 =2.5). DIff is like 3-2.5=0.5

If it is possible, Please share me.

Thanks,

Chiru