Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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?