Convert rows into Columns

ashishpalkar — Thu, 13 Aug 2015 23:40:28 GMT

Hi There

I have requirement like below , in below table we can see Time Period. I want to show Time Period as Columns and show respected revenue for that time period.

Time_Period	Total Revenue	ID	QV_Date	Abc	CDE
18 Months May2012-Oct2013	114603.954	1	7/31/2015	2	139
Apr-15	116.4	2	7/31/2015	2	103
Aug-13	-3511.76919	3	7/31/2015	2	139
Aug-14	28068.82035	4	7/31/2015	2	139
Aug-14	4.052706201	5	7/31/2015	2	103
Current YTD	9000	6	7/31/2015	2	139
Current YTD	16100	7	7/31/2015	2	139
Current YTD	454.15	8	7/31/2015	2	103
Current YTD	709.83	9	7/31/2015	2	107
Current YTD	347.65	10	7/31/2015	2	103
Dec-14	682.2468466	11	7/31/2015	2	103
Dec-14	48205.09874	12	7/31/2015	2	139
Feb-14	8011.51497	13	7/31/2015	2	139
Feb-15	375.15	14	7/31/2015	2	103
Jan-14	75206.01616	15	7/31/2015	2	139
Jan-15	9000	16	7/31/2015	2	139
Jan-15	79	17	7/31/2015	2	103
Jan-15	709.83	18	7/31/2015	2	107
Jul-13	41657.78445	19	7/31/2015	2	139
Jul-14	10029.85977	20	7/31/2015	2	139
Jul-14	77410.45768	21	7/31/2015	2	139
Jun-14	223.2450495	22	7/31/2015	2	103
Jun-14	100246.3363	23	7/31/2015	2	139
Mar-14	88834.30823	24	7/31/2015	2	139
Mar-15	16100	25	7/31/2015	2	139
Mar-15	231.25	26	7/31/2015	2	103
May-13	9027.179335	27	7/31/2015	2	139
May-14	637.1705961	28	7/31/2015	2	103
May-14	100236.0096	29	7/31/2015	2	139
Nov-13	6016.991937	30	7/31/2015	2	139
Nov-14	5308.531809	31	7/31/2015	2	107
Nov-14	240.5037763	32	7/31/2015	2	103
Oct-13	9037.446026	33	7/31/2015	2	139
Oct-14	630.1156618	34	7/31/2015	2	103
Oct-14	5017.731422	35	7/31/2015	2	139
Oct-14	4153.507468	36	7/31/2015	2	107
Oct-14	140.3393602	37	7/31/2015	2	103
Prior Full Year	630.1156618	38	7/31/2015	2	103
Prior Full Year	10029.85977	39	7/31/2015	2	139
Prior Full Year	5247.170688	40	7/31/2015	2	103
Prior Full Year	692577.941	41	7/31/2015	2	139
Prior Full Year	9462.039277	42	7/31/2015	2	107
Q1 2012	9528.770293	43	7/31/2015	2	109
Q1 2012	2156.469785	44	7/31/2015	2	109
Q1 2014	172051.8394	45	7/31/2015	2	139
Q1 2015	9000	46	7/31/2015	2	139
Q1 2015	16100	47	7/31/2015	2	139
Q1 2015	454.15	48	7/31/2015	2	103
Q1 2015	709.83	49	7/31/2015	2	107
Q1 2015	231.25	50	7/31/2015	2	103
Q2 2012	1653.065077	51	7/31/2015	2	109
Q2 2013	9027.179335	52	7/31/2015	2	139
Q2 2014	200482.3459	53	7/31/2015	2	139
Q2 2014	860.4156456	54	7/31/2015	2	103
Q2 2015	116.4	55	7/31/2015	2	103
Q3 2013	96539.32868	56	7/31/2015	2	139
Q3 2014	10029.85977	57	7/31/2015	2	139
Q3 2014	266820.9256	58	7/31/2015	2	139
Q3 2014	3323.665059	59	7/31/2015	2	103
Q4 2013	15054.43796	60	7/31/2015	2	139
Q4 2014	630.1156618	61	7/31/2015	2	103
Q4 2014	1063.089983	62	7/31/2015	2	103
Q4 2014	9462.039277	63	7/31/2015	2	107
Q4 2014	53222.83016	64	7/31/2015	2	139
Rolling 12 Months	5701.320688	65	7/31/2015	2	103
Rolling 12 Months	977.7656618	66	7/31/2015	2	103
Rolling 12 Months	26129.85977	67	7/31/2015	2	139
Rolling 12 Months	10171.86928	68	7/31/2015	2	107
Rolling 12 Months	529526.1017	69	7/31/2015	2	139
Rolling 18 Months	5701.320688	70	7/31/2015	2	103
Rolling 18 Months	977.7656618	71	7/31/2015	2	103
Rolling 18 Months	26129.85977	72	7/31/2015	2	139
Rolling 18 Months	10171.86928	73	7/31/2015	2	107
Rolling 18 Months	707594.933	74	7/31/2015	2	139
Rolling 24 Months	5701.320688	75	7/31/2015	2	103
Rolling 24 Months	977.7656618	76	7/31/2015	2	103
Rolling 24 Months	26129.85977	77	7/31/2015	2	139
Rolling 24 Months	822198.887	78	7/31/2015	2	139
Rolling 24 Months	10171.86928	79	7/31/2015	2	107
Rolling 36 Months	5701.320688	80	7/31/2015	2	103
Rolling 36 Months	977.7656618	81	7/31/2015	2	103
Rolling 36 Months	26129.85977	82	7/31/2015	2	139
Rolling 36 Months	822198.887	83	7/31/2015	2	139
Rolling 36 Months	10171.86928	84	7/31/2015	2	107
Sep-13	58393.31342	85	7/31/2015	2	139
Sep-14	3319.612353	86	7/31/2015	2	103
Sep-14	161341.6476		7/31/2015	2	139

Required Output Needed

ID	Header 4	Header 5	Total Revenue	Jan 2014	Feb 2014	Mar 2014	Apr 2014	May 2014	Jun 2014	Jul 2014	Aug 2014	Sep 2014	Oct 2014	Nov 2014	Dec 2014	Jan 2015	Feb 2015	Mar 2015	Apr 2015	May 2015	Jun 2015
0	A	www	$6831.07	$4387.76	$2443.31	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
1	Ba	2ad	$390.13	$269.75	$120.38	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
2	ww	assas	$2586.71	$1516.37	$1070.34	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Re: Convert rows into Columns

maximiliano_vel — Fri, 14 Aug 2015 00:36:35 GMT

This you need on LOAD or in Presentation?

With your sample data (large table) the first columns ID, Header4, Header5 where are they come from?

By the way didn't you post this already? Show Last 18 Months Data

Regards

Re: Convert rows into Columns

sunny_talwar — Fri, 14 Aug 2015 01:08:12 GMT

I am not sure how you have reached the output from the given data set you have provided above. May be if you can elaborate it a little, someone here might be able to help you better

Best,

Sunny

Re: Convert rows into Columns

Anonymous — Fri, 14 Aug 2015 01:13:11 GMT

Hi Ashish,

Could you please post sample app.

Re: Convert rows into Columns

Fri, 14 Aug 2015 02:34:59 GMT

Create a Pivot table with ID, Header4 , Header5 & TImePeriod as dimensions & required expressions.

Drag the TimePeriod to top like columns.

Re: Convert rows into Columns

awhitfield — Fri, 14 Aug 2015 10:04:27 GMT

IS this not the same as your other POST? In which case, just use a pivot table

Andy

topic Re: Convert rows into Columns in QlikView

Convert rows into Columns

Re: Convert rows into Columns

Re: Convert rows into Columns

Re: Convert rows into Columns

Re: Convert rows into Columns

Re: Convert rows into Columns