Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Date Column Help

Hi

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 ..

NameService Name01/01/1202/01/1203/01/1204/01/1205/01/1206/01/1207/01/1208/01/1209/01/1210/01/1211/01/1212/01/12TOTAL 2012
companyService         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 2Service 2        7,271         7,271         7,271         7,271         7,271         7,271         7,271         7,271            908            908            943            943      61,866
Company 3Services 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

1 Solution

Accepted Solutions
Not applicable

Date Column Help

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);

View solution in original post

3 Replies
Not applicable

Date Column Help

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);

View solution in original post

Not applicable

Date Column Help

Thanks For your help!! 

Not applicable

Date Column Help

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