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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
risht2
Contributor
Contributor

Displaying Current, previous and Next months data based on date filter on Qlik Sense

Hi team, I am very new to Qlik sense. So please excuse me if this has been previously discussed in any forums

I have a chart which shows change in value with respect to previous month and a date filter

Want I have to do is if I click on 1 particular date, the chart should show only three months

  1. Previous month change wrt to previous month
  2. Current month change wrt previous month
  3. Next month change wrt to previous month

I tried creating three different date filed one of Previous month, current month and next month. But I am not being able to add them all in Bar chart.

Calculations used

month(max(Date)) for Current month or filtered month; month(addmonths(max(date),+1)) for next month and month(addmonths(max(date),-1)) for previous month.

0 Replies