topic Re: PAST SIX MONTH COMPARISON in QlikView

PAST SIX MONTH COMPARISON

Tue, 25 Feb 2014 20:44:26 GMT

I WANT TO COMPARE MY CURRENT MONTH WITH LAST SIX MONTH SALES.

EG. WHEN I SELECT (JAN 2014) I WANT THE PIVOT TABLE TO SHOW ME LAST SIX MONTHS AS SHOWN BELOW IN SALES (DETACHED) PIVOT TABLE.

ANY SUGGESTIONS???

Re: PAST SIX MONTH COMPARISON

aveeeeeee7en — Tue, 25 Feb 2014 20:54:23 GMT

Use this in your expression:

Sum( {$<Date={">=$(=MonthStart(AddMonths(Max(Date),-6)))<$(=MonthEnd(Max(Date)))"}>} Sales)

Re: PAST SIX MONTH COMPARISON

jerem1234 — Tue, 25 Feb 2014 20:54:29 GMT

Maybe something like:

sum({<MonthYear = {'>=$(=addmonths(max(MonthYear), -6))<=$(=max(MonthYear))'}>}Sales)

If nothing is selected, it will take show the latest 6 months.

Hope this helps!

Re: PAST SIX MONTH COMPARISON

Tue, 25 Feb 2014 21:08:48 GMT

Hey jerem,

i am using the same expression to get my sales for last six month but when i change -6 to -5 its giving me the same result as -6.

Re: PAST SIX MONTH COMPARISON

jerem1234 — Wed, 26 Feb 2014 13:00:51 GMT

Does it also give the same result as -4? Have you tried using Nag Aviral's formula? Can't be sure why its giving you that result, could you post a sample qvw demonstrating the problem?

Re: PAST SIX MONTH COMPARISON

Wed, 26 Feb 2014 15:32:21 GMT

I figured it out With Jerem's/nag expression.

thanks guys.