topic Re: Import Excel to qlik view in QlikView

Import Excel to qlik view

mr_ramshini — Wed, 25 Nov 2020 16:16:04 GMT

I need to samples qvw file that use of excel file

Thanks

Re: Import Excel to qlik view

trdandamudi — Wed, 14 Sep 2016 04:48:21 GMT

Follow the below link:

Loading Excel Data into QlikView

Re: Import Excel to qlik view

ramasaisaksoft — Wed, 14 Sep 2016 05:01:53 GMT

Hi Hossein,

Load A,

FROM

(ooxml, embedded labels, table is Market);

just change the path after the From so that you will get excel file.

else go to script(Ctrl + E)->Right hand side (Down) you will find there Table File button -> click on that and choose the specific excel file->click finish button.

Importing Data from Excel into Qlik (QlikView) - YouTube

this video will show the entire thing

Re: Import Excel to qlik view

Anil_Babu_Samineni — Wed, 14 Sep 2016 05:21:26 GMT

I request you to don't create two thread for single issue

Help

Is This you are expecting?

Re: Import Excel to qlik view

mr_ramshini — Wed, 14 Sep 2016 05:33:28 GMT

my excel file have several sheets and i have different values to each them

but i want create a chart for each sheet that each chart is different to other sheets

Re: Import Excel to qlik view

sasikanth — Wed, 14 Sep 2016 05:44:42 GMT

Hi,

Every sheet of excel can be considered as a table ,

so try to load all sheets one by one and use the data to create individual charts for every sheet.

if the structure of every sheet is similar then use filter in script to differentiate values.

PFB screen shot

Please let me know if it not the solution you are looking for..