topic Re: Calendar Object with Variable in QlikView

Calendar Object with Variable

Corona7 — Sat, 30 Jan 2021 23:24:25 GMT

Hi, I set a variable in my load script and i want use it in a calendar objetc ad in expressions.

Let Data_riferimento = date(today(0).'DD/MM/YYYY');

When i use the variable in my Calendar Object is show correctly

but after the load script and i use the variable in an expression it's no working

The first expression is (year(date($(Data_riferimento),'DD/MM/YYYY'))) & ' (YTD)' and i expect 2021 instead 1899.

Only if i select le date on the calendar object the date then then expression works.

Where is my mistake ? I need that after the load the variable is equal the formula date(today(0).'DD/MM/YYYY') and the expression wotks correctly.

Thanks

MayilVahanan — Sun, 31 Jan 2021 01:37:43 GMT

For your expression, $() not required. try like below

= (year(date(Data_riferimento,'DD/MM/YYYY')))

Vegar — Sun, 31 Jan 2021 07:38:04 GMT

I see two possible issues with your expression. Try this adjusted version.

year(date#('$(Data_riferimento)' ,'DD/MM/YYYY')) & ' (YTD)'

Corona7 — Sun, 31 Jan 2021 10:37:57 GMT

Thanks Mayil Vahanan, it's works! 👍

Corona7 — Sun, 31 Jan 2021 10:42:22 GMT

Thanks Vegar! It's works! 👌