topic Re: Starting problem in QlikView

Starting problem

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

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

krishnacbe — Thu, 13 Apr 2017 16:03:38 GMT

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 — Thu, 13 Apr 2017 17:30:17 GMT

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 — Thu, 13 Apr 2017 17:59:22 GMT

Hi,

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

Anonymous — Thu, 13 Apr 2017 18:18:25 GMT

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