topic Re: Cross table is not working in QlikView

Cross table is not working

alec1982 — Tue, 17 Jul 2012 16:08:13 GMT

Hi,

I loaded a table from Excel file which looks like:

Company 2008 2009 2010 2011

ABC 10 20 5 3

CDE 5 10 3 2

Data:

CrossTable(year, Data)

LOAD Company,

2008,

2009,

2010,

2011

FROM

(biff, embedded labels, table is [revenue& Ops$]);

When I applied Cross table from the Edit script. I was able to see the values right. but after loading it and trying to use it in the qvw..it shows me the

both fields Years and Data with the value of the years

Years Data

2008 2008

2009 2009

2010 2010

2011 2011

Any Idea or help?

Thxs,

Re: Cross table is not working

Tue, 17 Jul 2012 16:39:19 GMT

Like this?

Kiran.

Re: Cross table is not working

cesaraccardi — Tue, 17 Jul 2012 16:51:50 GMT

Hi,

this happens because QlikView generates the load script without the brackets in the field names making them constant values "2008", "2009" for all the rows. Try with the brackets, like this:

Data:

CrossTable(year, Data)

LOAD Company,

[2008],

[2009],

[2010],

[2011]

FROM

(biff, embedded labels, table is [revenue& Ops$]);

Regards,
Cesar

Re: Cross table is not working

bgerchikov — Tue, 17 Jul 2012 16:59:29 GMT

Try this one as well:

Re: Cross table is not working

alec1982 — Tue, 17 Jul 2012 17:28:17 GMT

perfect. all the above helped.

Thxs,