Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rcorcoran
Creator
Creator

bar chart showing 3 rolling years

Hi I am trying to crete a bar chart with three rolling years in it so if it is march 2016 it will show back to march 2015 etc.

I have it working when I have current year and previous year data but when I put in the third year I the december figure or most recent figure either doubles or is wrong

the dimension is month and the expressions I have are:

Current year:

=num(Sum({$<CIFCode ={'26.204.18'},ReferredYYYY, YearMonth={">=$(=AddMonths(Max({<CIFCode ={'26.204.18'}>}YearMonth), -11))<=$(=Max({<CIFCode ={'26.204.18'}>}YearMonth))"}>}ActualValue)

/Sum({$<CIFCode ={'26.204.15'},ReferredYYYY, YearMonth={">=$(=AddMonths(Max({<CIFCode ={'26.204.15'}>}YearMonth), -11))<=$(=Max({<CIFCode ={'26.204.15'}>}YearMonth))"}>}ActualValue),'##0%')

Current year - 1:

=num(Sum({$<CIFCode ={'26.204.18'},ReferredYYYY=, YearMonth={">=$(=AddMonths(Max({<CIFCode ={'26.204.18'}>}YearMonth), -24))<=$(=Addmonths(Max({<CIFCode ={'26.204.18'}>}YearMonth),-12))"}>}ActualValue)

/Sum({$<CIFCode ={'26.204.15'},ReferredYYYY=, YearMonth={">=$(=AddMonths(Max({<CIFCode ={'26.204.15'}>}YearMonth), -24))<=$(=Addmonths(Max({<CIFCode ={'26.204.15'}>}YearMonth),-12))"}>}ActualValue),'##0%')

Current year - 2:

=num(Sum({$<CIFCode ={'26.204.18'},ReferredYYYY=, YearMonth={">=$(=AddMonths(Max({<CIFCode ={'26.204.18'}>}YearMonth), -35))<=$(=Addmonths(Max({<CIFCode ={'26.204.18'}>}YearMonth),-24))"}>}ActualValue)

/Sum({$<CIFCode ={'26.204.15'},ReferredYYYY=, YearMonth={">=$(=AddMonths(Max({<CIFCode ={'26.204.15'}>}YearMonth), -35))<=$(=Addmonths(Max({<CIFCode ={'26.204.15'}>}YearMonth),-24))"}>}ActualValue),'##0%')

Thanks

1 Reply
sunny_talwar

Just be looking at the expression, nothing seems to stand out. Would you be able to share a sample to show your issue?