Crosstable

Mon, 08 Jun 2009 17:45:14 GMT

Good Morning,

if i type this command the script give me an error.

crosstable

(mese, qta, 4)

LOAD

CodiceProdotto,

Anno

TipoFornitore

Fornitore

QtaGennaio

as 1,

QtaFebbraio

as 2,

QtaMarzo

as 3,

QtaAprile

as 4,

QtaMaggio

as 5,

QtaGiugno

as 6,

QtaLuglio

as 7,

QtaAgosto

as 8,

QtaSettembre

as 9,

QtaOttobre

as 10,

QtaNovembre

as 11,

QtaDicembre

as 12

FROM xxxxxxx.mdb

but if i type this command

CONNECT

TO xxx.mdb

ALIAS

QtaGennaio AS 1;

ALIAS

QtaFebbraio AS 2;

ALIAS

QtaMarzo AS 3;

ALIAS

QtaAprile AS 4;

ALIAS

QtaMaggio AS 5;

ALIAS

QtaGiugno AS 6;

ALIAS

QtaLuglio AS 7;

ALIAS

QtaAgosto AS 8;

ALIAS

QtaSettembre AS 9;

ALIAS

QtaOttobre AS 10;

ALIAS

QtaNovembre AS 11;

ALIAS

QtaDicembre AS 12;

crosstable

(mese, qta, 4)

SELECT

FROM xxx.mdb

it work well.

But i need to use the first script because in the crosstable operation i have to select only some filed.

Crosstable

Mon, 08 Jun 2009 19:15:18 GMT

Hi Margio,

It would be much easier for us to help if you will attach an example of the QV application.

Kind regards,

JTPro

Crosstable

Mon, 08 Jun 2009 21:16:22 GMT

What is the error that you get?

topic Crosstable in QlikView

Crosstable

Crosstable

Crosstable