Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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 - Specialist III
Partner - Specialist III

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

Anonymous
Not applicable
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 - Specialist III
Partner - Specialist III

Hi,

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

Anonymous
Not applicable
Author

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