compare each month to the same month last year?

[#1]

Hello,

I have a pretty basic table and I need to compare the turnover of each month vs the same month last year :

- Date

- Day

- Month

- Year

- Turnover

Something like

=Sum(Turnover) /  Sum( {Day=, Month=SameMonthAsTheleftPart,YearMonth=YearFromTheLeftPart - 1>} Turnover)

Is it possible?

I hope you can help.

Many thanks!

[Gysbert_Wassenaar]

Yes, it's possible. Dozens have solved this issue before: https://community.qlik.com/search.jspa?q=same+month+year

[sunny_talwar]

May be look into this option as well: The As-Of Table

or share a sample where we can demonstrate some front end options using Above()/Below() functions.

[reddy-s]

Hi,

Its easier if you use a master calendar. Make use of the inMonth() function to create a flag and make use of this in the set analysis statement.

Thanks,

Sangram.