How to split date as month wise?

[#1]

Hi,

I have sample data as below in excel

CID     Date            Sales
UI9087 15/03/2010 10
UI9087 15/04/2010 10

UI9087 15/01/2011 10
UI9087 15/02/2011 10
UI9087 15/03/2011 10
UI9087 15/04/2011 10
UI9087 15/05/2011 10
UI9087 15/06/2011 10
UI9087 15/07/2011 10
UI9087 15/08/2011 10
UI9087 15/09/2011 10
UI9087 15/10/2011 10
UI9087 15/11/2011 20
UI9087 15/12/2011 15

I need to show output as below.

CID	Mar2010	Apr2010	Jan2011	Feb2011	Mar2011	Apr2011	May2011	Jun2011	Jul2011	Aug2011	Sep2011	Oct2011	Nov2011	Dec2011
UI9087	10	10	10	10	10	10	10	10	10	10	10	10	20	15

Can anyone suggest me how to get this please.

[Anonymous]

Have a look at the MonthName() function.

[giakoum]

in every application that includes dates, a calendar should be created.

see here : http://community.qlik.com/message/227963#227963

[buzzy996]

1.create pivot table with dimension as CID & DATE

2.create expression sum(sales)

3. move DATE row AS COLUMN

4.make ur date name by using date functions.