Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
rathnam_qv
Creator
Creator

Cross Table issue

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.

 

 

4 Replies
Or
MVP
MVP

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. 

rathnam_qv
Creator
Creator
Author

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.

Or
MVP
MVP

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/Scrip...

 

rathnam_qv
Creator
Creator
Author

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