topic Re: Dates grouped data columns in QlikView

Dates grouped data columns

Wed, 05 Aug 2015 01:30:32 GMT

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

Re: Dates grouped data columns

sunny_talwar — Wed, 05 Aug 2015 03:03:35 GMT

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

Re: Dates grouped data columns

Thu, 06 Aug 2015 01:24:21 GMT

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