Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

michielvandegoo
Valued Contributor

Script parameters, additional info needed

Hi,

I'm unable to find any additionale info about the Script paramaters option in Publisher.

If I understand correctly this function would enable me to read a tabel from my document. Take each value one-by-one and create a new document for this value.

Does this mean a variable can be set with script parameters?

I need to reload 1 document against 7 datasets that are all equal except for the content. Each data is in a different folder.

Therefore I want to set the variable from the 'Script parameter' to each folder with the dataset one after another.

If this is possible to do with the 'Script parameter ' function, how does this work in the Qlikview script? How do I set the value for the variable. Is that the column name?

Tags (1)
3 Replies
Employee
Employee

Re: Script parameters, additional info needed

Here is a document that we use in training. It has a variable call "MyRegion" that you can set the value to the RegionName.

region.png

You would do that here.

qv11SR2-2013-02-28-15-17-25.png

This will cause it to create one document for each value. However, if you are not careful you will end up with only one document. You have to make sure you name the documents different some how. Below is an example of that.

qv11SR2-2013-02-28-15-15-45.png

Notice that I am using the document name and then adding the region to the end.

Bill

michielvandegoo
Valued Contributor

Re: Script parameters, additional info needed

Bill, thanks.

This works only with 1 data base?

I have 7 folders with CSV files. I can reload by setting a variable and point to the folder. But can Script parameter do this too?

My Select statement looks like this:

$(DATA)\file.csv     where $(DATA) is the folder name, for instance: folder_1, folder_2 etc.

Not applicable

Re: Script parameters, additional info needed

Hi Michiel,

Did you ever find a solution to your problem?

I'm running into a similar issue, which I've posted about here: Multiple Reloads & Publishes with Publisher

Thanks,

Ken

Community Browser