topic how to use let variable in front end? simple example pls? in QlikView

how to use let variable in front end? simple example pls?

Sat, 15 Feb 2014 06:55:37 GMT

how to use let variable in front end? simple example pls?

thanks

Re: how to use let variable in front end? simple example pls?

Gysbert_Wassenaar — Sat, 15 Feb 2014 08:55:55 GMT

You can define a variable in the script or in the Variable Overview (from the Settings menu) in the front end. Once a variable is defined you can use it in expressions. An example:

Define a variable vToday that will contain the numeric value of todays date:

LET vToday = num(today());

Use the variable vToday in a set analysis expression to sum the sales of the last three months:

sum({<SalesDate={'>$(=addmonths($(vToday),-3))<=$(vToday)'}>} Sales)

Re: how to use let variable in front end? simple example pls?

Sat, 15 Feb 2014 09:17:18 GMT

Hi Gysbert,

we can call by setting variable by 'SET' as well but is there any advantage is there using ' LET' exactly here.

regards

Mahesh T

Re: how to use let variable in front end? simple example pls?

Gysbert_Wassenaar — Sat, 15 Feb 2014 09:19:28 GMT

See this blog post: The Magic of Variables