topic Re: Variable declaration on Script in QlikView

Variable declaration on Script

Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I have a simple problem that i can't resolve.

I want to put in my script the declaration of a variable that includes another variable:

Set vCurrentWeek = "max({<[Calendar-Year]={$(v_MaxYear)}>} [Calendar-Week])";

And i want that when i recompile this script, in the variable declaration appear the $(v_MaxYear) literally, not expanded with the value.

Result:

Expected:

It's posible?

Thanks in advance,

Ivan.

Re: Variable declaration on Script

rubenmarin — Fri, 29 Jul 2016 11:13:18 GMT

Hi Ivan, to avoid that you can replace the $ by another symbol, and load it using 'LET' and Replace(). Check this answer by Marcus Sommer: Re: Setting a variable in script...

And as a bonus, from the same author: Variables

In your case it can be:

Let vCurrentWeek = Replace('max({<[Calendar-Year]={#(v_MaxYear)}>} [Calendar-Week])', '#', '$');

The same can be used with simple quotes (if needed):

Let vCurrentWeek = Replace(Replace('max({<[Calendar-Year]={|#(v_MaxYear)|}>} [Calendar-Week])', '#', '$'), '|', Chr(39));

Re: Variable declaration on Script

jonathandienst — Fri, 29 Jul 2016 11:23:38 GMT

Its called 'deferring the $ expansion'.

Re: Variable declaration on Script

Anil_Babu_Samineni — Fri, 29 Jul 2016 11:32:38 GMT

Set vCurrentWeek1 = max([Calendar-Year])

Set vCurrentWeek = Sum({<[Calendar-Year] = {"=$(vCurrentWeek1)"}>}Sales)

Good Luck

Re: Variable declaration on Script

Fri, 29 Jul 2016 13:08:50 GMT

Thanks all for the quick replies,

It works perfectly, thanks rubenmarin‌

BR,

Ivan