Qlik Community

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF). Providing best practices, libraries and utilities that facilitate the recommended setup and management of QlikView or Qlik Sense environments. An understanding of the Qlik platform is recommended before joining this group. Download QDF and documentation here: https://github.com/QlikDeploymentFramework/Qlik-Deployment-Framework/releases

Highlighted
bmenicucci
New Contributor III

Identify what environment we are

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

1 Reply
bmenicucci
New Contributor III

Re: Identify what environment we are

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