topic how to create dynamic variables in qlikview in QlikView

how to create dynamic variables in qlikview

nagarjuna005 — Wed, 17 Oct 2018 11:45:30 GMT

Hello Experts,

can anyone explain me on how to create dynamic variables in qlikview with one example.

thanks in advance.

Sergey_Shuklin — Wed, 17 Oct 2018 12:19:55 GMT

Hello!

You can use a link to another variable or use values as a parameters with dollar sign:

This is more than dynamical, in my honest opinion 😃

nagarjuna005 — Wed, 17 Oct 2018 12:54:15 GMT

thanks for the reply shuklin

i have created a variable like vStartDate = 01/15/2018 and vEndDate = 02/15/2018.

while loading data into qlikview it will only from 01/15/2018 to 02/15/2018

but tomorrow i want data till 10/15/2018 in this case how to create a dynamic variable with out changing dates manually.

i am looikng like this

rwunderlich — Wed, 17 Oct 2018 13:24:43 GMT

To assign a computed value to a variable, use the LET statement in the script. Examples:

LET vEndDate = today(1);

LET vEndDate = MonthStart(today(1));

-Rob

Zhandos_Shotan — Wed, 17 Oct 2018 13:43:53 GMT

Another way:

// get last date according to your dataset

Let vLastDate = '=Max(YourDateField)';

Example:

Sum( {<YourDateField = { $(vLastDate) }> } Value)

Regards