Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
helvegen
Contributor
Contributor

Starting problem

hi all,

how can i add xlsx files and open ODBC connection for sql commands, please help i'm new and i'm trying it for 3 days now, cant realy get how it works

4 Replies
krishnacbe
Partner
Partner

Hi,

Connect to Excel:

You need to go to Edit Script -> Data -> Table Files Button and select the excel file you want to import.

Connect to SQL using ODBC:

1. Create System DSN in ODBC

2. Edit Script -> Data -> Database -> Select ODBC from drop down and click on Connect button

If you face any specific issue share the error screen to help you more

helvegen
Contributor
Contributor
Author

I'll show you some screenshots, please tell me what i'm doing wrong and how it must done.

I've added data (with data add button) and then i cant do anything. Thanks for attention.

krishnacbe
Partner
Partner

Hi,

Please post the Query in Qlik Sense Forum to get fast response.

helvegen
Contributor
Contributor
Author

i've asked there, thanks for you're help