Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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
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