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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Crosstable Problem

Hi *,

I have a excel table that looks like this

Salescategory I Salescategory II Salescategory III
Customer|Name| 2005|2006|2007 2005|2006|2007 2005|2006|2007


Normally I would use crosstable to load the data. My Problem is that I alos need the "Salescategory information."
Is there a way to transform the excel file in QV?
Thanks for your help.

Regards

Aloah

1 Reply
Not applicable
Author

Is it possible to merge cells during load? in this case merge row 1&2, do a crosstable load and split them afterwards again?