topic Re: Sub Cells in cell in Pivot or Straight Table in QlikView

Re: Sub Cells in cell in Pivot or Straight Table

Fri, 23 Aug 2013 04:30:15 GMT

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

Re: Re: Sub Cells in cell in Pivot or Straight Table

Alejandro_Hernández — Fri, 23 Aug 2013 05:21:19 GMT

see attached

Re: Sub Cells in cell in Pivot or Straight Table

Fri, 23 Aug 2013 07:53:35 GMT

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

Re: Re: Sub Cells in cell in Pivot or Straight Table

ashwanin — Fri, 23 Aug 2013 08:44:11 GMT

Hi Chiru,

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

I have attached w/o resource data.

rgds

Ashwani

Re: Re: Sub Cells in cell in Pivot or Straight Table

sparur — Fri, 23 Aug 2013 09:00:02 GMT

Hi Please see in my attach

Re: Sub Cells in cell in Pivot or Straight Table

Fri, 23 Aug 2013 09:08:45 GMT

HI Kumar,

Yes, there should be 'Resource Name' necessarily.

Thanks,

Vamsi

Re: Sub Cells in cell in Pivot or Straight Table

Gysbert_Wassenaar — Fri, 23 Aug 2013 12:21:32 GMT

Use excel. This is not possible in Qlikview.

Re: Sub Cells in cell in Pivot or Straight Table

sparur — Fri, 23 Aug 2013 12:26:55 GMT

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

Re: Sub Cells in cell in Pivot or Straight Table

Alejandro_Hernández — Fri, 23 Aug 2013 12:46:06 GMT

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

Re: Sub Cells in cell in Pivot or Straight Table

Fri, 23 Aug 2013 16:58:38 GMT

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

Re: Sub Cells in cell in Pivot or Straight Table

sparur — Thu, 29 Aug 2013 12:10:39 GMT

Hi Chiru

Do you see my example?

I think it was what you need...