topic CrossTable error in QlikView

CrossTable error

Mon, 17 Jan 2011 11:45:09 GMT

Hi,

I would to like to import data from a crosstable

I creat a new application to test the crosstable import. Everything is Ok.

I do the same thing in an existed application, QV crash after I pasted my code or after I wrote "CrossTable("

Are there any parameter to active to use Crosstable ?

Have you got any idea to explain this error ?

Thanks

CrossTable error

maneshkhottcpl — Mon, 17 Jan 2011 11:47:36 GMT

Hi,

Please send ur script or sample application. i will help u.

CrossTable error

sparur — Mon, 17 Jan 2011 11:50:27 GMT

Hello,

I think you could create some mistakes in Crosstable parameters. Can you post your qvw?

CrossTable error

Mon, 17 Jan 2011 12:06:24 GMT

OptionPrint:
CrossTable(Tableau, OptionPrint)
LOAD Utilisateur,
CH1145,
CH1144,
CH1010,
CH205,
CH206,
CH675,
CH06,
CH470,
CH100,
CH595,
CH810,
CH854,
CH1124,
CH1445,
CH510,
CH606,
CH529,
CH621,
CH615,
CH625,
CH629,
CH605,
CH609
FROM
[\\pc-1007\userdat\\Secu_Qv_glob.xls]
(biff, embedded labels, header is 1 lines, table is OptionPrint$);

CrossTable error

sparur — Mon, 17 Jan 2011 12:24:41 GMT

hmm, strange.

At first look, all is good.

what about if you try this:

1) Add 3rd parameter = 1, like this: crosstable(Tableau, OptionPrint, 1) LOAD...

2) to comment crosstable statement (load by columns) may be you haven't access into XLS file.

P.S. what you see in the log file when your script is down?