Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have done extensive research on variable connections strings and have tried many ways to get connection load tables I continue to get error when running debug No qualifed path for file:****
We use Windows Integrated security connection
SET vMyServerName = (sql server Microsoft OLE DB Provider for SQL Server)
SET vMyDatabaseName = 'dbo';
SET vMyCatalogName = '(catalog name)';
Set vConnectionString1 = OLEDB CONNECT TO [Provider=SQLOLEDB;Integrated Security=SSPI;Data Source=$(Server_name);Initial Catalog=$(Catalog_Name);Database=$(dbo)';
LOAD * FROM '$(vMyServerName)'.'$(vMyDatabaseName)'.'$(vMyCatalogName)'.'table_nm';
Sense doesn't support setting of Connections in Standard Mode. Create the connection and then connect or load from it.
for OLE DB connections, you would have a
LIB CONNECT TO 'yoursource';
Then any load would reference data available from that data connection definition. Only one connection is active at a time.
desktop version does not support variable connection strings?
i meant ..
I do have a lib connection string
lib CONNECT TO '$(vConnectionString1)';
Qlik Sense does not