Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

CrossTable error

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

4 Replies
maneshkhottcpl
Partner - Creator III
Partner - Creator III

Hi,

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

sparur
Specialist II
Specialist II

Hello,

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

Not applicable
Author

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

sparur
Specialist II
Specialist II

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?