How do I access data from multiple Excel sheets from the same file?
I am brand new to QlikSense and am trying to use an Excel document with multiple sheets. Let's call these sheets A, B, C, D, and E. Using the quick data load I was able to upload the Excel spreadsheet and I can see from looking at the Data Load Editor that the data from all the different sheets has been loaded. I want to create separate sheets in QlikSense where each sheet references a specific sheet from the Excel spreadsheet. However, when I go to create a new sheet in QlikSense, I am only given the option to show fields from either "A" or "all tables" and from experimenting some I've seen that QlikSense either only uses data from sheet A or aggregates the data from all the different sheets. How can I get QlikSense to only draw from the specific Excel sheets?
Re: How do I access data from multiple Excel sheets from the same file?
If you select the "consolidated" data or a selection of sheets you will get a number of LOAD statements in your script. For each LOAD add a line that identifies the particular sheet that the data comes from like this:
Lines 20 and 28 has been added by me. Similarly you will have to add one such line to each of your LOAD statements.
Then you can use a Set Expression in your charts to filter out the particular rows for the particular sheet like this: