Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Excel data import

I have data in excel and want to import in qlikview to generate chart for that.

how to do.

Thanks.

1 Solution

Accepted Solutions

Re: Excel data import

Hi,

Go to the script editor, then select Table Files... and follow the wizard to load the data right. That will create a script that will work every time you click on Reload.

Hope that helps.

Miguel

3 Replies

Re: Excel data import

Hi,

Go to the script editor, then select Table Files... and follow the wizard to load the data right. That will create a script that will work every time you click on Reload.

Hope that helps.

Miguel

Not applicable

Re: Excel data import

Got one MDB source and had created the connection.but not getting the options how to load the tables from *mdb file to qlikview.

Please suggest some option

Re: Excel data import

Hi,

Prior to that, you need to create an ODBC using the "Connect" button in the script editor. If you already had done that, then use the button "Select" instead of the "Table file". There you will see a dialog with two main parts: the left one with the tables, views, etc, and the right one with the field names. Select and click on the "Add" button to generate the script.

You have got some free training and introduction to QlikView here.

Hope that helps.

Miguel

Community Browser