Environment Variable setup in Qlikview (To Make connection string configurable) same as SSIS
I was just trying to make the path configurable so that when we move from Development to production environment, we should change the path only in configuration and should not open the code and change the path or connection string.
To Achieve this, I added all my configurable variables in a text file (qlikview_file_config.txt) and include that file in my script.
SET vDWHConnectionString='[Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DB_NAME;Data Source=SERVER_NAME;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=ABC;Use Encryption for Data=False;Tag with column collation when possible=False]';
SET vDimQVDStoragePath='D:\Shivendoo\Dim Data Source QVD Files';
SET vFactQVDStoragePath='D:\Shivendoo\Fact Data Source QVD Files';
SET vBKPDimFolderPath='D:\Shivendoo\QVD BackUp\Dim Data Source QVD Files';
SET vBKPFactFolderPath='D:\Shivendoo\QVD BackUp\Fact Data Source QVD Files';
SET vArchieveQVDsFolderPath='D:\Shivendoo\Archieve QVDs';
//This condition will allow to load only 2 years of Data from Today()