How to pass parameters into a Variable

stevedark — Thu, 16 Jun 2016 08:18:15 GMT

Hi,

I've just posted a new blog entry with a tutorial showing how you can pass parameters into variables.

This opens up a number of opportunities for code re-use, and allows code to be tidied up - particularly in the load script.

Examples are given of how you can use this technique to convert and format dates in your load script.

There is also a full example of how you can create a variable that allows you to calculate the number of working days between two dates, excluding weekends and public holidays. This variables uses the NetworkDays function, and takes a list of public holidays from a spreadsheet, so it can be updated without having to modify the code.

Please see this post for details:

http://bit.ly/1tspB7A

Please let me know in the comments on that post if you have any questions, or further ideas how that technique can be applied.

Steve

Re: How to pass parameters into a Variable

Anil_Babu_Samineni — Thu, 16 Jun 2016 08:49:50 GMT

Article some kind interesting.

Q) I have two graphs, I want to store those two graphs into two Variables is that possible?

Re: How to pass parameters into a Variable

stevedark — Thu, 11 Aug 2016 15:13:44 GMT

You can not put the graph into a variable, but you can the expression that drives it. This is generally more than half of the battle.

topic Re: How to pass parameters into a Variable in QlikView

How to pass parameters into a Variable

Re: How to pass parameters into a Variable

Re: How to pass parameters into a Variable