Create a year button using a Date field

laragalvan — Mon, 16 Sep 2024 18:46:51 GMT

Hi community! I have the following example data in a Bar Chart in Qlik Sense (Dimension: year(Issue Date), Measure: sum(Total)) and I want to create a button (action button or similar) for each year in order to select one of them and see how dynamically the bar chart change. The idea is avoid a filter pane. I tried several options in "Button Items" but at the moment nothing seems to work out. Which configurations should I use to achieve this?

Example data:

Issue Date Total USD

01/01/2024 10

01/05/2024 20

04/08/2024 20

03/01/2023 30

02/03/2023 40

01/09/2023 50

Example Bar Chart:

What I tried so far:

Thanks!

Re: Create a year button using a Date field

anat — Tue, 17 Sep 2024 02:33:37 GMT

create a Year field from Issue Date then use Year in button "Selection in Field"

load *,year([Issue Date]) as Year;

load * inline [

Issue Date,Total USD

01/01/2024,10

01/05/2024,20

04/08/2024,20

03/01/2023,30

02/03/2023,40

01/09/2023,50

];

topic Create a year button using a Date field in App Development

Create a year button using a Date field

Re: Create a year button using a Date field