topic Crosstable syntax in QlikView

Crosstable syntax

Wed, 24 Oct 2012 10:58:42 GMT

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

Re: Crosstable syntax

Gysbert_Wassenaar — Wed, 24 Oct 2012 11:27:32 GMT

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

Re: Crosstable syntax

Thu, 25 Oct 2012 12:49:42 GMT

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.

Re: Crosstable syntax

alexpanjhc — Thu, 25 Oct 2012 15:58:27 GMT

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.

Re: Crosstable syntax

Thu, 25 Oct 2012 16:18:32 GMT

Hi,

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

CrossTable([Quick Stats1], Data)

Hope this helps !!!

Regards

Re: Crosstable syntax

Thu, 25 Apr 2013 08:27:15 GMT

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.

Re: Crosstable syntax

sushil353 — Thu, 25 Apr 2013 08:32:30 GMT

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

Re: Crosstable syntax

Mon, 29 Apr 2013 07:56:20 GMT

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