Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
];