topic Re: Code reusability in QlikView

Code reusability

rash_611 — Mon, 30 Dec 2013 11:30:14 GMT

Hi,

i need to calculated business hours for many date fields. there are mutiple lines of code for the same to calculate.

Can any one suggest how to reuse the same lines of code many times for different date fields.

Regards,

Grace

Re: Code reusability

Gysbert_Wassenaar — Mon, 30 Dec 2013 11:33:56 GMT

Put the expressions (or parts of expressions) in variables. You can put the code the creates the variables in a text file that you include in the script with the include statement: $(Include=mysharedcodefile.qvs);

This way you can include the script file in many qlikview documents. You can then use the variables in chart expressions. If you need to change something you will only have to change it in one place, in the script file. The change will be applied to any document that uses the script file after reloading the document.

Re: Code reusability

Anonymous — Mon, 30 Dec 2013 11:37:25 GMT

You can define your global variables with logic required.

And then you can use these variables as many times you like.

Re: Code reusability

Mon, 30 Dec 2013 11:39:26 GMT

Maybe user defined functions can help you here. These are defined as variables in the QlikView script, e.g.

set vDiffMonths = Round(interval(date($2) - date($1)) / 30);
set vDiffQuarters = Round(interval(date($2) - date($1)) / 90);

set vDiffMonths2 = ((YEAR(date($2))-YEAR(date($1)))*12)+(MONTH(date($2))-MONTH(date($1)));
set vDiffQuarters2 = ((YEAR(date($2))-YEAR(date($1)))*3)+(ceil(Month(date($2))/3)-ceil(Month(date($2))/3));

You would then reference the function like this:

$(vDiffMonths('12/04/2011','05/02/2012'))

You can also store them in an Excel spreadsheet that can be imported into the QVW. This makes the functions easy to manage. See the solution that Karl Pover recommends here: http://community.qlik.com/message/89749

Re: Code reusability

rash_611 — Tue, 31 Dec 2013 05:12:55 GMT

hi, thanks for ur reply.. can u explain me how to creat that with any example...