Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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.

 

 

Labels (1)
4 Replies
Or
Master II
Master II

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
Master II
Master II

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.