In Qlik Sense, access to the filing system i.e., absolutely the or relative path of system files depends upon which mode the user is using. There are two modes, namely, Standard mode and Legacy mode. within the standard mode, no such file path or function or variable is supported which exposes or gives the user access to the filing system. So, if a user wants to realize access into the filing system and use complete file paths to system files, then standard mode must be disabled. Instead, a legacy mode is activated which isn’t as secure because the standard mode and makes the system files vulnerable to risk.

What are the restrictions in Standard Mode?

If you employ the unsupported functions and variables within the data load script while working within the standard mode, then the error is produced by the system. While the error is generated, then the script returns NULL.
In this section, we’ll discuss some system variables, regular script statements, script control statements, file functions, and system functions.

i. System Variables

• Variable: Floppy (First letter of the floppy drive, like a: etc.)
Standard mode/ Qlik Sense Cloud: Not supported

Legacy mode: Supported
• Variable: CD (First letter of the CD ROM drive.)

Standard mode/ Qlik Sense Cloud: Not supported
Legacy mode: Supported

• Variable: QvPath (Returns the trail to the Qlik Sense executable file.)
Standard mode/ Qlik Sense Cloud: Not supported
Legacy mode: Supported

• Variable: QvRoot (Returns the basis directory to the Qlik Sense executable file)
Standard mode/ Qlik Sense Cloud: Not supported
Legacy mode: Supported

• Variable: QvWorkPath (Returns the browse string of the currently opened Qlik Sense app)
Standard mode/ Qlik Sense Cloud: Not supported
Legacy mode: Supported

• Variable: QvWorkRoot (Returns the basis directory of the currently opened Qlik Sense app)
Standard mode/ Qlik Sense Cloud: Not supported
Legacy mode: Supported

• Variable: WinPath (Returns the browse string of the Windows)
Standard mode/ Qlik Sense Cloud: Not supported
Legacy mode: Supported

• Variable: WinRoot (Returns the basis directory of the Windows)
Standard mode/ Qlik Sense Cloud: Not supported
Legacy mode: Supported

• Variable: $(include=…) (This variable stores a file containing the text which must be included within the data load script during execution)

Standard mode/ Qlik Sense Cloud: Supported

Legacy mode: Supported

ii. Regular Script Statements

• Statement: Binary

Description: Loads data from other apps.

Standard mode/ Qlik Sense Cloud: Supported

Legacy mode: Supported

Recommended Reading – Qlik Sense Troubleshooting

• Statement: Connect

Description: Establishes a connection to databases using ODBC or OLE DB connections.

Standard mode/ Qlik Sense Cloud: Supported

Legacy mode: Supported

• Statement: Directory

Description: Gives the name of the directory.

Standard mode/ Qlik Sense Cloud: Supported

Legacy mode: Supported

• Statement: Execute

Description: Runs and executes other programs while data is loaded in Qlik Sense’s memory.

Standard mode/ Qlik Sense Cloud: Not Supported

Legacy mode: Supported

• Statement: LOAD from…

Description: Returns the browse string of the QS executable file.

Standard mode/ Qlik Sense Cloud: Supported

Legacy mode: Supported

• Statement: Store into…

Description: Returns the basis directory of the QS executable file.

Standard mode/ Qlik Sense Cloud: Supported

Legacy mode: Supported

iii. Script Control Statements

• Statement: For each…

Filelist mask/dirlist mask

Description: The filelist mask returns the list of all files separated by comma present within the current directory.
And, dirlist mask returns an inventory of all directories separated by comma present within the current directory
Standard mode/ Qlik Sense Cloud: Supported

Legacy mode: Supported

iv. File Functions

• Function: Attribute()

Description: For meta tags of the media files.

Standard mode/ Qlik Sense Cloud: Supported

Legacy mode: Supported

• Function: ConnectString()

Description: Connect strings like ODBC or OLE DB connections.

Standard mode/ Qlik Sense Cloud: Supported

Legacy mode: Supported

• Function: FileDir()

Description: Path of the directory like the table file currently being read.

Standard mode/ Qlik Sense Cloud: Supported

Legacy mode: Supported

• Function: FilePath()

Description: Full path of the table file being read by the script engine.

Standard mode/ Qlik Sense Cloud: Supported

Legacy mode: Supported

• Function: FileSize()

Description: File size (in bytes) of a selected file or the table currently being read.

Standard mode/ Qlik Sense Cloud: Supported

Legacy mode: Supported

• Function: FileTime()

Description: Timestamp of the last modification wiped out a file.

Standard mode/ Qlik Sense Cloud: Supported

Legacy mode: Supported

• Function: GetFolderPath()

Description: Full path for a Microsoft Windows folder.

Standard mode/ Qlik Sense Cloud: Not supported

Legacy mode: Supported

• Function: QvdCreateTime()

Description: Timestamp as an XML-header for a QVD file.

Standard mode/ Qlik Sense Cloud: Supported

Legacy mode: Supported

• Function: QvdFileName()

Description: Name of a field during a QVD file, like its field number.

Standard mode/ Qlik Sense Cloud: Supported

Legacy mode: Supported

• Function: QvdNoOfFields()

Description: Total number of fields during a QVD file.

Standard mode/ Qlik Sense Cloud: Supported

Legacy mode: Supported

• Function: QvdNoOfRecords()

Description: Total number of records during a QVD file.

Standard mode/ Qlik Sense Cloud: Supported

Legacy mode: Supported

• Function: QvdTableName()

Description: Name of the table stored during a QVD file.

Standard mode/ Qlik Sense Cloud: Supported

Legacy mode: Supported

v. System Functions

• Function: DocumentPath()

Description: Full path of the currently read Qlik Sense app/document.

Standard mode/ Qlik Sense Cloud: Not supported

Legacy mode: Supported

• Function: GetRegistryString()

Description: Value of a registry key with an outlined name and a given registry path.

Standard mode/ Qlik Sense Cloud: Not supported

Legacy mode: Supported

How to Disable Standard Mode?

In order to use the restricted functions and variables again within the Qlik Sense data load script, you would like to disable the quality mode hence, enabling the legacy mode. Although, it should be kept in mind that disabling the quality mode exposes the files to potential risks.

One way to disable the quality mode is thru the Qlik Sense QMC. differently for disabling standard mode in Qlik Sense Desktop, is by setting standard/legacy mode in Settings.ini. The Settings.ini file is found in C:\Users\{user}\Documents\Qlik\Sense\Settings.ini.

To enable the legacy mode, follow the steps given below.

• Open Settings.ini during a text editor.
• Change StandardReload=1 to StandardReload=0. Where 1 is for normal mode and 0 is for legacy mode.
• Save the file and begin the Qlik Sense Desktop.

So, this brings us to the end of blog. This Tecklearn ‘Qlik Sense Filing System’ blog helps you with commonly asked questions if you are looking out for a job in Qlik Sense BI. If you wish to learn Qlik Sense and build a career in Business Intelligence domain, then check out our interactive, Qlik Sense Certification Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

Qlik Sense Certification Training

Qlik Sense Certification Training

About the Course

Qlik Sense is a revolutionary Business Analytics tool to come from the Qlik stables. It provides powerful self-service analytics that are readily deployable through interactive and personalized dashboards, data visualization techniques and insightful reports. By the end of this Qlik Sense online training, you will be able to perform key skills of the self-service BI tool – Qlik Sense, such as self-service analytics, write data load scripts, data discovery, create dashboards, develop and share apps, create reports, and design and build data visualizations. All these skills will enable you to clear the Qlik Sense certification exam.

Why should you take Qlik Sense Training?

• The average annual pay for a Qlik Sense Professional is $101,871. -Indeed.com.
• HSBC, Alstom, Chrysler, Citibank, Accenture and many other MNC’s worldwide use Qlik Sense BI and it has a market share of around 5% globally.
• By the end of 2020, the market is expected to touch USD 22.8 billion as modern BI and analytics continue to expand more rapidly, Gartner said in a report.

What you will Learn in this Course?

Introduction and Installation of Qlik Sense

• Need for self-service Business Intelligence/Business Analytics
• Installation of Qlik Sense and Qlik Sense Desktop

Qlik Sense Features

• Qlik Data indexing engine
• Data dimensions relationships
• Types of Data Loading
• Types of Concatenation

Data Modelling

• Qlik Sense data architecture
• Understanding QVD layer
• Converting QlikView files to Qlik Sense files
• Incremental Load
• Scripting
• Create Master Calendar

Advance Data Modelling

• Qualify and unqualify
• Joins
• Keep
• Cross Table
• Let Vs Set
• Calendar Table Creation

Qlik Sense Enterprise

• Various Functions
• Create QVD Files
• Read Data for QVD Files
• Create QVD’s
• Create Tier 2 Qlik Sense App

Data Visualization

• Expressions
• Variables
• Extensions
• Data Visualization

Set Analysis

• Set analysis in Qlik Sense
• Use set expression like identifiers, operators, modifiers and comparative analysis

Advance Set Analysis

• Deploy comparison sets and perform point-in-time analysis

Qlik Sense Storytelling

• Storytelling feature of Qlik Sense
• Create a story and playback the story

Qlik Sense Visualization

• Qlik Sense Charts
• Advanced Charts
• Creating Dashboards
• Real Life Examples

Security

• Security aspects of Qlik Sense
• Security rules

Got a question for us? Please mention it in the comments section and we will get back to you.

563