Documents for QlikView related information.
for a project we are using a significant amout of varibles most of them related to a timestamp.
To manage al possible outcomes and get insight in al the exceptions used we introduced the INLINE Statement to put al values into a table.
With the values of the time stamp used to fill in some fields a good insight into the values and depencies has been realised.
Here's an example(simplified):
let vToday = today() -1; let vYear = year ($(vToday)); let vPrevYear = $(vYear) - 1; let vtmpStartDate = date(monthstart($(vToday))); // for extraction Daily Sales load * inline [ var_name, var_formula, var_value, var_comment, var_usage vToday,"today()-1",'$(vToday)',"current date deffered by 1" vYear,"(vYear)",'$(vYear)',"" vtmpStartDate,"date(monthstart((vToday)))" ,'$(vtmpStartDate)',"// for extraction Daily Sales " vPrevYear,"(vYear) - 1",'$(vPrevYear)',"" ];
This is amazing. I was trying for the same thing and this article saved me!