Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

compare each month to the same month last year?

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!

3 Replies
MVP & Luminary
MVP & Luminary

Re: compare each month to the same month last year?

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


talk is cheap, supply exceeds demand

Re: compare each month to the same month last 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.

reddys310
Honored Contributor II

Re: compare each month to the same month last year?

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.

Community Browser