Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Not applicable

help:cross table

Hi,

I have an excel file with this kind of format:

LedgerDeptChannelAccountLine
Project1....12
Ledger1110Acc0111Prj91100
98
Ledger2220Acc0212Prj92200
198
Ledger3330Acc0313Prj93300
298
Ledger4440Acc0414Prj94400
398
Ledger5550Acc0515Prj95500
498

column 1 ... 12 are the month columns, when I try to use the cross table function in qlikview it gives me the wrong amount per month.

Like this

MonthAmount
11
22
33
44
55
66
77
88
99
1010
1111
1212
1 Solution

Accepted Solutions
Not applicable

Re: help:cross table

I already solved the problem,

my original load statement is

CrossTable(Month,MonthValue,6)

Load Ledger,

Dept,

Channel,

Account,

Line,

Project,

1,

2,

3,

4,

5,

6,

7,

8,

9,

10,

11,

12

From Excel Source;

i enclosed the month columns in square brackets [ ] ..

CrossTable(Month,MonthValue,6)

Load Ledger,

Dept,

Channel,

Account,

Line,

Project,

[1] as Jan,

[2] as Feb,

[3] as Mar,

[4] as Apr,

[5] as May,

[6] as Jun,

[7] as Jul,

[8] as Aug,

[9] as Sep,

[10] as Oct,

[11] as Nov,

[12] as Dec

From Excel Source;

Now my question, what is the use of the square brackets??

2 Replies
Not applicable

Re: help:cross table

I already solved the problem,

my original load statement is

CrossTable(Month,MonthValue,6)

Load Ledger,

Dept,

Channel,

Account,

Line,

Project,

1,

2,

3,

4,

5,

6,

7,

8,

9,

10,

11,

12

From Excel Source;

i enclosed the month columns in square brackets [ ] ..

CrossTable(Month,MonthValue,6)

Load Ledger,

Dept,

Channel,

Account,

Line,

Project,

[1] as Jan,

[2] as Feb,

[3] as Mar,

[4] as Apr,

[5] as May,

[6] as Jun,

[7] as Jul,

[8] as Aug,

[9] as Sep,

[10] as Oct,

[11] as Nov,

[12] as Dec

From Excel Source;

Now my question, what is the use of the square brackets??

Highlighted
adhudson
Contributor II

Re: help:cross table

Hi,

     The field name could be in any format.

     For instance, it can contain spaces, symbols such as slash, comma, etc..,

     In your case, the field or column names are numbers.

     It purely depends on the names defined in the sources.

     To make it available to qlikview, i.e., to make such exceptional fields as a column, you need to include square brackets or double quotes at the start and end of the formatted column name.

     In SQL, it is suggested to use double quotes to such column names.

     Hope this helps.

Regards

Andrew Hudson