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
- Previous month change wrt to previous month
- Current month change wrt previous month
- Next month change wrt to previous month
I tried creating three different date fileds one of Previous month, current month and next month. But I am not being able to add them all in a single 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.
