topic Re: Identify what environment we are in Archived Groups

Identify what environment we are

bmenicucci — Tue, 22 Jul 2025 17:59:49 GMT

Hello qlikers,

I've a quick question for you laid on the beach!

I'm using my QDF scripts in both Qlik Sense and Qlik View. The question is: how do I know, from a script perspective, which environment I am dealing with? This can be useful, for instance, during an automated "LOAD" of QVDs: if you are in QS, to identify the path of the file you have to use "/" while in QV you have to use "\".

Any idea?

Thanks a lot and have a nice summer time!

Brunello

Re: Identify what environment we are

bmenicucci — Tue, 14 Aug 2018 15:20:12 GMT

This is my actual script: it looks like I'm able to make it work on QS or QV but not both!

LET QVD = '$(vG.LoadPath)';

// Generate the Loop for each value in the LIST_OF_TABLES table

FOR EACH vFileName IN filelist(QVD& '\*.qvd')

IF NOT ISNULL('$(vG.HomeContainer)') THEN

LET vFileBaseName=replace(subfield('$(vFileName)', '/', -1), '.qvd', '');

ELSE

LET vFileBaseName=replace(subfield('$(vFileName)', '\', -1), '.qvd', '');

ENDIF

[$(vFileBaseName)]:

LOAD

FROM $(vFileName) (qvd);

next vFileName