Discussion Board for collaboration related to QlikView App Development.
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
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
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.
Please post the Query in Qlik Sense Forum to get fast response.
i've asked there, thanks for you're help