Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Reading data tables left to right?

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

- Marcus

Employee
Employee

Re: Reading data tables left to right?

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
Community Browser