Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to pull data from multiple excel sheet or multiple tabs as a Data source in Qlikview?
Hi JSK,
you can upload different sheets of the same excel file.
Follow this path: FILE - EDIT SCRIPT - TABLE FILES - choose your excel file - choose your sheet in TABLES (there is a drop down menù).
If the tables/sheets that you upload have the same set of fields and the fields have the same name, QV automatically concatenate the tables/data even if the source is different (the second table is treated as a continuation of the first).
Hope this helps.
Mattia