I am new and I would like to learn how to work in Qlikview

[#1]

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

[MayilVahanan]

HI Maria,

Please refer the screenshot. In tables tab, you can able to select the sheet name.

Hope it helps

[amit_saini]

Maria,

Follow link :

Re: Import multiple sheets in excel

Thanks,

AS

[#4]

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

[jagan]

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.