Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cross table columns into multiple field boxes

I have successfully imported data using the cross table function.  This created 3 list boxes.

Now I see that segmenting the columns from my original XLSX file into 2 list boxes would really be best for my analysis.  What is the best course of action?

I've tried entering the load script twice and commenting out the desired columns for each respective statement but was unsuccessful..

1 Reply
hic
Former Employee
Former Employee

It is not clear to me what you want to do... A crosstable cannot have fewer than three entities: In the picture below: Product, Month and Sales. Hence (at least) three fields.

Crosstable transformation4.png

HIC