How can i change the format in the below data by year ??

[Silambarasan1306]

Office	EmployeeID	2008	2009	2010	2011	2012
1	2	2,000	24,000	15,000	10,000	10,000
	9		20,000	50,000	80,000	1,00,000
2	1	5,000	40,000	60,000	80,000	1,00,000
	8	30,000	50,000	80,000	1,00,000
3	4		13,000	50,000	80,000	1,00,000
	5			50,000	80,000	1,00,000
4	6		10,000	50,000	80,000	1,00,000
5	3		40,000	50,000	80,000	1,00,000

[Colin-Albert]

Can you give more details of what format you are expecting to change?

Perhaps an example of your data and the expected output.

[satishkurra]

Use Cross Table Load in QlikView

[Colin-Albert]

The Crosstable Load

[avinashelite]

you can Pivot table also ....please provide  the sample data and your requirement will help you out with the solution

[Anonymous]

Cross Table is the answer

Try like this?

CrossTable(Year, Sales)

LOAD Office,

     EmployeeID,

     [2008],

     [2009],

     [2010]

      [2011],

      [2012]

FROM

(ooxml, embedded labels, table is Sheet3);

[sasikanth]

HI,

Try this

CrossTable(YEAR,Sales,2)

LOAD * INLINE [

Office, EmployeeID, 2008, 2009, 2010, 2011, 2012

1,E101,100,200,100,200,400

  2,E102,100,200,100,200,400

   3,E103,100,200,100,200,400

    4,E104,100,200,100,200,400

     5,E105,100,200,100,200,400

]

[jagan]

Hi,

Try like this

CrossTable(Year, Sales, 2)

LOAD

*

FROM DataSource;

Hope thsi helps you.

Regards,

jagan.

[Silambarasan1306]

Thank u All

[jagan]

Hi,

If you got the answer close this thread by giving Correct & Helpful answers to the posts which helps you in getting the answer.

Regards,

Jagan.