Solved: Default to current year but enable user to select ... - Qlik Community

Abhi999 · ‎2020-02-03

I want to show current year by default and then want a option to to select required years in waterfall chart.i tried below but not working Re: Default to current year but enable user to select from year dropdown list as well

,[JDE.Year] = {$(=RangeMin(max([JDE.Year]),Year(today())))

jonathandienst · ‎2020-02-04

With that set expression, the user can make a selection of JDE.Year and the value will change to that year, providing it is not more than 2020 (year(today()).

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

Taoufiq_Zarra · ‎2020-02-04

can you share a sample data ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

jonathandienst · ‎2020-02-04

With that set expression, the user can make a selection of JDE.Year and the value will change to that year, providing it is not more than 2020 (year(today()).

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Abhi999 · ‎2020-02-13

Thanks it is working fine.