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