topic Re: How to split date as month wise? in QlikView

How to split date as month wise?

Fri, 27 Feb 2015 12:38:48 GMT

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.

Re: How to split date as month wise?

Anonymous — Fri, 27 Feb 2015 12:39:50 GMT

Have a look at the MonthName() function.

Re: How to split date as month wise?

giakoum — Fri, 27 Feb 2015 12:42:23 GMT

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

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

Re: How to split date as month wise?

buzzy996 — Fri, 27 Feb 2015 15:03:56 GMT

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.