Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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

];