Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Yes, it's possible. Dozens have solved this issue before: https://community.qlik.com/search.jspa?q=same+month+year
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.
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.