Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I am really new.. I have a question? maybe is a silly question
I would like to import excel data to Qlikview, the sheets on the excel are named by years but the information for each sheet is the same .
by example:
sheet 2000_age. gender. symptoms and more
sheet 2001_age. gender. symptoms and more
sheet 2002_age. gender. symptoms and more and so
I tried to import them but I could not do it... it seem that only 2000 was import .
Sorry guys your knowledge are important for me....
Macosa
HI Maria,
Please refer the screenshot. In tables tab, you can able to select the sheet name.
Hope it helps
Have a read of this How to become a QlikView Developer? for a more general idea of how to learn QV, might help you going forward
Hi,
By default it will load the first sheet, if you want to load multiple sheets then you need to select other sheets manally and load the data.
Check this link to read all sheets
qlikviewcookbook.com/2008/09/loading-multiple-excel-sheets/
Hope it helps you.
Regards,
Jagan.