Dates grouped data columns

[#1]

Please help me,

I need to change the date row data column must be grouped code values for months,

Example: I have the following table on the server

data:
LOAD *;
SQL
SELECT DATE,ITEM,QUANTITY
FROM PDDTAEPM.DATA
 
STORE data INTO datasum.qvd(qvd);

DROP table data;

I have something like:

Date	Ítem	Quantity
01-jan-2015	123	10
10-jan-2015	123	15
15-jan-2015	100	5
25-jan-2015	100	20
30-jan-2015	200	10
02-feb-2015	123	30
10-feb-2015	200	15
18-feb-2015	200	10
24-feb-2015	200	5
27-feb-2015	100	10

but I need this

Ítem	Enero	Febrero
100	25	10
123	25	30
200	10	30

Thank you very much

[sunny_talwar · Accepted solution]

Looking to get this???

Script:

Table:

LOAD *,

  Month(Date) as Month,

  MonthName(Date)as MonthYear;

LOAD Date#(Capitalize(Date), 'DD-MMM-YYYY') as Date,

    Ítem,

    Quantity

FROM

[https://community.qlik.com/thread/175280]

(html, codepage is 1252, embedded labels, table is @1);

Create a Pivot Table with Item and MonthYear as Dimension and Sum(Quantity) as expression.

HTH

Best,

Sunny

[#3]

Again thank you very much,

I already have as well as the months I mean, how do I add January and February, February and March, March and April and so on. I need to add two and two and leave the results in a column. Because then I get the standard deviation of the months grouped in pairs.

Please help me as I do this?

I need this?

ìtem	Monthyear	jan-15	feb-15	mar-15	apr-15	sum(jan+feb)	sum(feb+mar)	sum(mar+apr)	standard deviation
100		25	10	10	5	35	20	15	10,41
123		25	30	20	10	55	50	30	13,23
200		10	30	30	5	40	60	35	13,23

Thanks