Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Avigdo
Contributor II
Contributor II

Action Button - selecting a range of dates from Jan to a variable stored month

Hi,

The DB has 2 fields: dates (from Jan 2017) and Income.

There is a variable of max_month (for instance - "Sep").

There is A Bar Chart:  A bar of summarized income for each year.

I would like to place a Button that switches between 2 Bar layouts:

1. No Filters: A Bar for every year - previous years gets full year income, current year - only until the last month in DB. The comparison between full Year and Partial Year is something Not Fair...

2. A filterd Bars to the Range off month between months Jan and the variable month (max month in DB <> max calendar month). To show the same period every Year.

 

Unfortunately I could only put "="  to allow the user to pick the last month itself.

Is there A solution for my problem?

Labels (3)
0 Replies