topic Generate years in a row in QlikView

Generate years in a row

Jogi — Sat, 16 Nov 2024 02:22:48 GMT

Hi, does anybody know the easiest way to get value

let vYears = '2019','2020','2021'

Thank you

AdiPai — Thu, 26 Sep 2019 12:55:13 GMT

Hey Jogi ,

the below should provide you an idea of how this can be done -

Result

Jogi — Thu, 26 Sep 2019 13:01:28 GMT

I need something like that :

anushree1 — Thu, 26 Sep 2019 13:01:37 GMT

what value are you looking for in case you want to generate the below yrs dynamically you could probably use:

let vYears =year(today())&','&year(AddYears(Today(),1))&','&year(AddYears(Today(),2));

Jogi — Thu, 26 Sep 2019 13:17:47 GMT

hey I still get just numbers, but I need years with quotation marks like '2019' ,'2020' ....an so on

anushree1 — Thu, 26 Sep 2019 13:28:26 GMT

I do not understand the need in this requirement as you are representing year numbers using string.

But, you can get what you need by using the below statement:

let vYears =chr(39)&year(today())&chr(39)&','&chr(39)&year(AddYears(Today(),1))&chr(39)&','&chr(39)&year(AddYears(Today(),2))&chr(39)

anushree1 — Thu, 26 Sep 2019 13:29:25 GMT

I do not understand the need in this requirement as you are representing year numbers using string.

But, you can get what you need by using the below statement:

let vYears =chr(39)&year(today())&chr(39)&','&chr(39)&year(AddYears(Today(),1))&chr(39)&','&chr(39)&year(AddYears(Today(),2))&chr(39);