topic Re: Can we import script file into Qliksense? in App Development

Can we import script file into Qliksense?

swarup_malli — Tue, 02 Feb 2016 19:44:15 GMT

Is anyone aware of the feature that allows them to import script file into Qliksense like its done in Qlikview.

Currently I have to copy the script and paste it in the script editor of Qliksense

Re: Can we import script file into Qliksense?

undergrinder — Wed, 03 Feb 2016 08:29:41 GMT

Hi Swarup_Malli,

You can use the include statement.

from Script Syntax and Chart Functions Guide:

Include The include variable specifies a file that contains text that should be included in the script. The entire script can thus be put in a file. This is a user-defined variable. This variable supports only folder data connections in standard mode.

Syntax:

$(Include =filename)

Example:

$(Include=abc.txt);

$(Include=lib://MyDataFiles\abc.txt);

If you don't specify a path, the filename will be relative to the Qlik Sense app working directory. You can also specify an absolute file path, or a path to a lib:// folder connection

The construction set Include =filename is not applicable.

HTH

Re: Can we import script file into Qliksense?

swarup_malli — Wed, 03 Feb 2016 14:00:45 GMT

Thank you ! for the response

I'm aware of that,I use Include statement very often (But even Include statement has to be manually typed in Qliksense unlike in Qlikview)

I meant somthing like this:

Re: Can we import script file into Qliksense?

undergrinder — Wed, 03 Feb 2016 14:03:53 GMT

This function is not implemented in QlikSense.

Re: Can we import script file into Qliksense?

gferran — Wed, 03 Feb 2016 14:08:06 GMT

Hi,

you can use the must_include sentence if you must be sure the file is loaded. This sentence will give you an error when reloading if the file script doesn't exist.

Regards

Re: Can we import script file into Qliksense?

undergrinder — Thu, 04 Feb 2016 09:57:17 GMT

I didn't know, that "must_include" statement is possible to use in Qlik Sense. I'll try it.

Re: Can we import script file into Qliksense?

Mon, 08 Feb 2016 14:07:26 GMT

Hi Swarup_Malli

If you think about a general Menu function to import scripts, then I haven't seen it in Qlik Sense either.

If you think about generally including scripts, then your syntax may look as follows - the " Lib.//000_Include " is a Qlik Sense Data Connector linked to the folder ...\000_Include where the scripts are stored as *.qvs files.

.. and yes, must-include works with Qlik Sense as well.. 🙂

Regards

// ********************* Main data Formats *****************************************************************************************

// Laden der zentral verwalteten Datenformate

// Load central repository of data formatting

$(Must_Include=lib://000_Include/general_formats_qv.qvs);

// Laden der zentral verwalteten Dateneingaben fuer Prompts in den SQL-Statements

// Load central repository of data-filters in prompts for sql statements

$(Must_Include=lib://000_Include/dates_prompts_qv.qvs);

// Laden der zentral verwalteten Definitionen für Corporate identity

// Load central definitions of Corporate Identity such as color theme, etc.

$(Must_Include=lib://000_Include/CI_Colors_qv.qvs);