topic Re: Cross Table issue in App Development

Cross Table issue

rathnam_qv — Mon, 20 Dec 2021 21:02:46 GMT

Hi All,

While i am trying to load "Cross Table" i am getting the following error.

"Generic tables must contain at least 3 fields"

Any know issues?

Thanks in advance!

Best Regards,

Muni.

Re: Cross Table issue

Or — Mon, 29 Mar 2021 13:40:21 GMT

Generic tables must contain at least three fields... does your generic table contain at least three fields? If you so, you may want to include your code and sample data, otherwise it's quite difficult to guess what the problem might be.

Re: Cross Table issue

rathnam_qv — Tue, 30 Mar 2021 03:55:18 GMT

Hi Or,

Thank you for your time.

I am not using Generic table. I am loading multiple excel files and using cross table on it.

Total i have 11 files. It's fetching records from first 4 tables then it's throwing the error "Generic tables must contain at least 3 fields". But it has more than 3 fields.

Thanks,

Muni.

Re: Cross Table issue

Or — Tue, 30 Mar 2021 07:44:44 GMT

The Crosstable prefix creates a generic table from a crosstable. You need at least three fields in the created generic table. This is actually covered in the documentation, so you may want to have a look at that since I don' think any explanation I'd provide would be better than the one they give:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/crosstable.htm

Re: Cross Table issue

rathnam_qv — Tue, 30 Mar 2021 11:17:36 GMT

i have fixed the issue. Issue is with Sheet Name.