Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
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!

0 Replies