Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
laragalvan
Contributor
Contributor

Create a year button using a Date field

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:

laragalvan_0-1726511886660.png

What I tried so far:

laragalvan_1-1726512019611.png

 


Thanks!

Labels (1)
1 Reply
anat
Master
Master

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

];