topic Re: Use button to select 2 values in a list in QlikView

Use button to select 2 values in a list

fgirardin — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I'm trying to create a button that would select the current and previous year in a list

YEAR field contains years in YYYY format from 2008 to 2017

Here is the list using my field "ANNEE"

If I use an action to select data in this field, I can select both year using

(2016|2017)

However this is means that I need to change it each year

I can select current year in my field using

=(Year(max(Date)))

But I can't find a way to select both current and previous year...

Is it possible ?

Thank you for your help

adamdavi3s — Tue, 14 Mar 2017 14:08:34 GMT

You need a select in field, then a toggle select in field

=(Year(max(Date)))

=(Year(max(Date)))-1

adamdavi3s — Tue, 14 Mar 2017 14:10:21 GMT

Please see the attached example

fgirardin — Wed, 15 Mar 2017 15:31:53 GMT

Hello Adam,

Thank you ! I was struggling to find a way and the solution was in front of my eyes the whole time XD

Have a nice day !