topic Date Column Help in QlikView

Date Column Help

Mon, 13 Feb 2012 18:57:00 GMT

I have the following Data Example, but I can’t find a way to group the date so it can be manage in QV, because it's separete ..

Name	Service Name	01/01/12	02/01/12	03/01/12	04/01/12	05/01/12	06/01/12	07/01/12	08/01/12	09/01/12	10/01/12	11/01/12	12/01/12	TOTAL 2012
company	Service	1,073	1,073	1,073	1,073	1,073	1,073	1,073	1,073	3,889	2,816	3,119	3,119	21,527
Company 2	Service 2	7,271	7,271	7,271	7,271	7,271	7,271	7,271	7,271	908	908	943	943	61,866
Company 3	Services 3									1,940	1,940	2,425	2,425	8,730

if you can see all Month are in different column, I want to know if there’sa way to group or work with this.

let me know if need more info ..

Thanks

Date Column Help

Mon, 13 Feb 2012 19:39:34 GMT

try with CrossTable(). For example:

Directory;

CrossTable(Month, Amount, 2)

LOAD Name,

[Service Name],

[01/01/2012],

[02/01/2012],

[03/01/2012],

[04/01/2012],

[05/01/2012],

[06/01/2012],

[07/01/2012],

[08/01/2012],

[09/01/2012],

[10/01/2012],

[11/01/2012],

[12/01/2012],

[TOTAL 2012]

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet2);

Date Column Help

Tue, 14 Feb 2012 13:18:39 GMT

Thanks For your help!!

Date Column Help

Fri, 17 Feb 2012 13:16:21 GMT

Hi,

I have the next situations and it is that the data I received have combined the year 2011 and 2012 in one file for example:

Is similar to the data above but adding the columns of year 2011 for example, I try to use the Cross table but it group all columns, I tryto not include those columns but when I try use the cross table it add all the column,

I want to know if there’s a way to do a cross table for those columns separately or another way to work with this thanks.

I will appreciate your help