Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

How to pass the DSN name in to qlikview document instead of hardcoding it

Hi All,

I am planning to deploy the qlikview application inside our windows application. To access the qlikview application and to load the data into qlikview I am using the AppPath. Now the question is how can i pass the DSN name into qlikview. One way of doing it is to read the DSN name from the ini file of our application. But I am not sure whether we can read from ini file using qlikview.

Other than this is there is any other way to pass the DSN name in to qlikview?


Let Path =QvWorkPath;

Sales:
ODBC CONNECT TO [Data]; //How to pass the DSN name here instead of hardcoding it here.
SQL SELECT SBU,
`PRD_CD`,
`PRD_DESC`,
TYPE,
PACKING,
`COMP_`,
BRAND,
ORG,
ZONE,
REGION,
AREA,
`HQ_DESC`,
DATE,
SQTY,
SVAL,
TQTY,
TVAL,
//FYEAR,
FORMU
FROM $(Path)\new3;//Here instead of hardcoding the path initialized AppPath and gave the AppPath while loading the data here


Some one please help me out!