Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reading data tables left to right?

Hello,

I need to read in data from left to right as opposed to top to bottom from an Excel spreadsheet.

For example the headers "Forecasted Target" and "Actual Target" are down the left hand side i.e A1 then A2 with then the results for every week going from left to right ie. Week 1 A1, Week 2 B2 etc.

To make things more complicated I have more than one table on each sheet, so need to make Qlik separate these tables when it reads in... is this possible?

Thanks

2 Replies
marcus_sommer

I assume that you are talking about a crosstable which could be handled with The Crosstable Load.

- Marcus

Michael_Tarallo
Employee
Employee

Hello Kieron -

In addition to what Marcus has stated - check out this video Power of Qlik Script - Reshaping Data with Crosstable (video) from this index New to Qlik Sense Videos and see if it helps.

Please let us know how you do.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik