Crosstable syntax

[#1]

Qlikview isnt likeing its own generated crosstable syntax, could i have an example so i can fix, also heres mine:

Quick_Stats:

CrossTable(Quick Stats1, Data)

LOAD [Quick Stats],

     [Quick Stats1],

     [Quick Stats2],

     [Quick Stats3],

     [Quick Stats4],

     [Quick Stats5],

     [Purchase info] &

     [Purchase info1]

FROM

[SOURCEEEEEEEE ]

(html, codepage is 1252, embedded labels, table is @3);

[Gysbert_Wassenaar]

Here's an example nicked from here

[Data]:

CrossTable(Months, Amount, 1)

LOAD * INLINE [

Department,    Jan,    Feb,    Mar,    Apr,    May,    Jun,    Jul,    Aug,    Sep,    Oct,    Nov,    Dec

Sales,    10,    20,    11,    33,    44,    13,    43,    56,    44,    66,    55,    22

Finance,20,    13,    14,    17,    18,    19,    20,    33,    22,    11,    34,    22

IT,    11,    22,    35,    53,    45,    62,    62,    33,    22,    11,    31,    11

];

Hope this helps

[#3]

Thankyou for your reply but this doesn't really help; load inline is used for when you knwo what the data is going to be, and will never change...

im using dynamic data hence load feilds is used.

[alexpanjhc]

for syntax, I'd go for the qlikview manual.

I wonder why not go through with the crosstable wizard when you build it?

I think in your example, you need 3 parameters. If you can tell what your error message is, that would help others to underatand your issue.

[#5]

Hi,

CrossTable(Quick Stats1, Data)   put Quick Stats 1 in bracket:

CrossTable([Quick Stats1], Data)

Hope this helps !!!

Regards

[#6]

It's because of CrossTable should be Crosstable([Quick Stats1],Data)

Obviously a bug for awhile cause just came across the same issue. Once I'd fixed the syntax went through perfectly.

[sushil353]

hi,

Why are u not using crosstable wizard while loading data to qlikview.

It seams that the problem in your code is Crosstable([Quick Stats1],Data)

HTh

Sushil

[#8]

It's because the crosstable wizard gets the syntax wrong and therefore you have to edit it manually.

Crosstable wizard adds a capital T when it needs to be Crosstable and not CrossTable