Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have created the dashboard in UAT environment using excel as a soruce data. Now I want to dynamically chane the environment (i.e. Prod or UAT). Can anyone help me how can I do that?
Thanks in Advance.
Cheers,
Varun
Massimo's excellent suggestion works like this:
Very simple and very powerful.
Best,
Peter
use variables for path folder
keep the path folder variable in an external file (txt, xls)
change the external file
Can you please explain me in detail?
Can you provide me any sample, as I never tried this?
put the include anincludeforpath.txt (attachment) and the a.qvw (attachment) in the same folder
adapt the folder in the include to your pc, reload, check the .qvd is stored in the path you set in the include
if you change one more time the path and reload the .qvd is stored in the new path
using the path variable QVDPath for read and store you can change from prod to dev to test, etc..... because all the files you read and store use the QVDPath
for excel you can do the same think, maybe is better to change the name of the variable in ExcelPath
// a.qvw
$(Must_Include=.\anincludeforpath.txt);
TABLE: load rowno() AutoGenerate 100;
STORE TABLE INTO [$(QVDPath)\TABLE.qvd] (qvd);
// include anincludeforpath.txt
SET QVDPath = 'C:\Users\mgrossi\Downloads';
trace i am an include;
First we need to create include anincludeforpath.txt
Set vsourcepath and vQVDpath.
Second we need to load from include anincludeforpath.txt
load * from
include anincludeforpath.txt?
Here how can we define Prod and UAT environment?
Regards,
Varun
Massimo's excellent suggestion works like this:
Very simple and very powerful.
Best,
Peter
Hi Peter,
I need to create two include files. One for UAT and one for Prod?
Yes, that's the idea.
All platform-dependent settings (mostly variables but you may have more) will go into an include file that is tied to the platform. You do not have to store stuff in this include file that doesn't change when moving between platforms, so you can keep it pretty clean.
Best,
Peter
Can you give me a sample script to load using include file.
The syntax I was trying:
set vSourceData = \\hbeu.adroot.hsbc\dfsroot\GB002\GDMP\01.GDMP\04. Data Quality\25. Data Quality Metrics & Reporting\98. Reporting\DQ_Qlikview\Production\Data Files;
set vQVDPath = \\hbeu.adroot.hsbc\dfsroot\GB002\GDMP\01.GDMP\04. Data Quality\25. Data Quality Metrics & Reporting\98. Reporting\DQ_Qlikview\Production\QVD;
Load
* from
$(Include=z:\gdmp\01.gdmp\04. data quality\25. data quality metrics & reporting\98. reporting\dq_qlikview\include files\include file.txt)\
DQIM_AllIssues_History - Master_Post.xlsx]
;
Will this work?