topic Re: Retrieve “Year” field value from a list of “YearMonth” values in App Development

Retrieve “Year” field value from a list of “YearMonth” values

LucaB-1991 — Wed, 22 Dec 2021 16:05:30 GMT

Hi everyone,

I need some help!

In qlik senso how can I extract years’values from a multiple selected YearMonth values?

For example:

If the user selects 201701, 201801,201901 from YearMonth filter box, in set analysis I want this behaviour : Year = {2017, 2018, 2019}.

Is there a way to achive this ?

DavidM — Mon, 09 Sep 2019 05:55:16 GMT

If YearMonth is $date type field you can do it with function Year(). Or you can use just left:

Year = {"=Left( [Year] ,4)"}

tresB — Mon, 09 Sep 2019 06:53:29 GMT

You can use a variable or the expression directly in set analysis.

= '{' & Concat(Distinct Left(YearMonth,4), ',' ) & '}'

LucaB-1991 — Mon, 09 Sep 2019 09:08:26 GMT

Thank you very much.
It works!