Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have different sheets in 1 excel file.
Each sheet represent one year data.
All the column and heading are same.
How do i load all sheets in Qliksense?
Please find attached as my scripting and excel sheets name.
Scripting
Excel Sheet Name
use
sheet1
concatenate
sheet2
Thanks for the suggestion.
The script would be really long and so much repetitive if i have lot of sheets.
Just wonder if there any better solution such as changing the last row of script.
You have to use a for loop to do that
you can check in the community and even if you find an answer for Qlikview you can change it for Qliksense
https://community.qlik.com/t5/New-to-QlikView/loading-all-sheets-data-from-excel/td-p/673784