Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mr_ramshini
Contributor III
Contributor III

Import Excel to qlik view

Hi

I need to samples qvw file that use of excel file

Thanks

5 Replies
trdandamudi
Master II
Master II

Follow the below link:

Loading Excel Data into QlikView

ramasaisaksoft

Hi Hossein,

Load A,

        B,

        C

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

Anil_Babu_Samineni

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

Help

Is This you are expecting?

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
mr_ramshini
Contributor III
Contributor III
Author

no

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

sasikanth
Master
Master

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

232585.png

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