Variables with $ and without $

gustavofred — Tue, 29 Dec 2020 12:47:05 GMT

Im trying to understand some code. When do i want to use $ in front of my variables and when not?

example 1:

let TodaysFirstdate = (num((today()) - (731 + 90)));
LET varMinDate = $(TodaysFirstdate);
LET varMaxDate = num(today()-1);
LET varToday = num(today());
LET maxYear = year($(varMaxDate));
LET minYear = year($(varMinDate));

example 2:

SQL SELECT
....
WHERE YEAR>= $(minYear) AND YEAR<= $(maxYear);

Re: Variables with $ and without $

edwin — Tue, 29 Dec 2020 18:14:49 GMT

qlikview evaluates anything inside he $() first before evaluating the script expression. it pretty much replaces the $ expansion with text or numbers, and then proceeds like normal script execution:

Dollar-sign expansion using a variable ‒ QlikView

topic Re: Variables with $ and without $ in QlikView

Variables with $ and without $

Re: Variables with $ and without $