Discussion board where members can get started with Qlik Sense.
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?
I assume that you are talking about a crosstable which could be handled with The Crosstable Load.
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.