topic Re: Edit script to add distribution information in QlikView

Edit script to add distribution information

Vegar — Mon, 26 Jan 2026 18:19:17 GMT

I'm trying to add a table with NTNAME etc. into the Governance Dashboard to enable the use of my client standard Loop and Distribute method in QMC. Running Governance Dashboard with the security code (or any code) added to the script, nothing happens.

Is it possible to add custom script to the governance dashboard?

Is there an "end script" command in the hidden script preventing me of adding custom code? Are there any work around. I tried binary load, but it feels like hidden script is run anyway.

Vegar Lie Arntsen

egbs consulting ab

http://bi-effekten.se

Re: Edit script to add distribution information

Tyler_Waterfall — Mon, 15 Sep 2014 20:58:37 GMT

Vegar Arnsten,

Yes, there is an "Exit Script" at the end of the script.

You basically have two options. Note that option 2 gets you into the "not supported" realm, so proceed at your own risk .

1) If you can get execute your script before the data is loaded, you can use the UserConfig script. You’d want to follow the instructions online about using a UserConfig script. (see HERE). Just create a .txt file with the script above in it, turn ‘on’ UserConfig script in the configuration page of the Governance Dashboard, and input the filepath to you UserConfig script.

2) Remove the hidden script in a copy of the Governance Dashboard and use "Binary"

Create a copy of the Governance Dashboard, calling it GovernanceDashboardNoScript.qvw
Create a new folder named “GovernanceDashboardNoScript-prj” in the same folder as the new .qvw
Open GovernanceDashboardNoScript.qvw, click SAVE, then close it.
You should now have many xml and other files in the –prj folder
Delete the DocBinary.dat file (contains the load script)
Open GovernanceDashboardNoScript.qvw again and click OK on the warning message
Save and close the app
Delete the PRJ folder
No you have an app without a script

Re: Edit script to add distribution information

Vegar — Tue, 16 Sep 2014 04:33:30 GMT

I'm the most comfortable with the binary load solution. I had already started on that, but could not get rid of the Gooden script.

I will however take a better look at the user config script feature in GD. I've totally overlooked that feature.

Thanks for the help Tyler.

/Vegar

Re: Edit script to add distribution information

Wed, 29 Oct 2014 06:21:01 GMT

Hi Tyler,

I'm trying on the second options, but I can't get the result for step 4#. Any advice?

Re: Edit script to add distribution information

Vegar — Wed, 29 Oct 2014 06:42:03 GMT

You should get an understanding of what the prj folder is. Google it or use this YouTube movie Creating prj Folder in QlikView - YouTube

Re: Edit script to add distribution information

Tyler_Waterfall — Wed, 29 Oct 2014 11:28:17 GMT

khoo cs - Be sure the name of the qvw and the -prj folder are the same. For example, if you kept the Governance Dashboard.qvw as is (did not rename), you would create a folder next to that .qvw called "Governance Dashboard-prj". Then open the Governance Dashboard.qvw, click Save, and close it. You should then see the files in the -prj folder.

If that's not working, make sure you have permissions in the folder where you make the -prj folder -- or, copy the Governance Dashboard.qvw to your local computer and try it there.

Re: Edit script to add distribution information

Thu, 30 Oct 2014 02:08:48 GMT

Yes, I don't have permission. Thanks. Solved!

Re: Edit script to add distribution information

Thu, 30 Oct 2014 02:09:42 GMT

Cool, I understand on the prj folder, just can't get the result because of permission. 😃 Anyway, solved and got it!

Re: Edit script to add distribution information

Thu, 13 Nov 2014 08:06:39 GMT

Hi Tyler,

Do you know how to define the excluded Files | Directories in Governance Dashboard? Says I defined a path in "List of file paths to scan", can I exclude several directories which located inside the path?

Re: Edit script to add distribution information

Tyler_Waterfall — Thu, 13 Nov 2014 12:18:04 GMT

Yes, this "excludes" is set using LUA patterns, as described here: Programming in Lua : 20.2

Personally, I have found I'm not super skilled at getting the right pattern down, but you might have more experience here.

Separate each folder to exclude using the vertical pipe |.

Here's the paragraph from the online doc about GovDB (HERE😞

In the Excluded Files | Directories entry fields, specify the files and directories to be excluded from the scan of the corresponding scan file path.
The scanner descends into all sub-directories of each scan path root directory to find all QVW, QVD and QVX files to analyze. One or more exclusion patterns (see Patterns) can be entered into the Excluded Keywords text field (separated by vertical bar | characters) to exclude from the metadata scan individual files or entire directories whose names match the exclusion pattern. Note that if the name of the candidate folder or file matches ANY one of the pipe-delimited patterns, the file or subfolder (and all of contents) is excluded from the scan.

Re: Edit script to add distribution information

Fri, 14 Nov 2014 06:02:40 GMT

Meaning, I need to separate the directories by | as below?

D:\Qlikview\Testing|D:\Qlikview\Testing2|D:Qlikview\Testing3

Re: Edit script to add distribution information

Tyler_Waterfall — Fri, 14 Nov 2014 11:18:04 GMT

Yes, though you might just be able to use simply:

Testing

Unless you have other subfolders or QVW, QVD, or QVX files with the string "Testing" in it that you do want to include in the scan. If not, though, you can include all items with "Testing" in the file path this way.

Please note that the LUA pattern is case sensitive.

If you are not sure the case of the folders and filenames, you might consider using the following:

[tT][eE][sS][tT][iI][nN][gG]

This captures both upper and lower case for each letter. seems a bit much for such a simple exclusion, but so it goes.

Re: Edit script to add distribution information

Tue, 18 Nov 2014 02:04:55 GMT

Thanks for the info. To make myself clear, meaning for example, I need to scan several paths.

Hence, in "List of File Paths to Scan", I put the root folder D:\Qlikview

In Excluded Files|Directories, I can just put the folder name like Backup|Testing|Docs|Model

Re: Edit script to add distribution information

Tyler_Waterfall — Tue, 18 Nov 2014 12:00:03 GMT

The List of File Paths to Scan will scan all the subfolders and files within that main folder (D:\QlikView). Then you can exclude files and subfolders within d:\QlikView by using the exclusion patterns, as you have listed them.

In your example, the scan would exclude all files within subfolders containing the case sensitive string "Backup", "Testing", "Docs" or "Model". It would also exclude any files containing that case-sensitive string.