Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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