Set analysis MOM

[nareshthavidishetty]

Hi,

The chart expression used is

• count({<AppStats={'Approved'}, Month={$(vMaxMonth)}, Year={$(vMax)}>}DISTINCT AppNUM)
• count({<AppStats={'Approved'}, Month={$(vMaxMonth)}, Year={$(vPrev)}>}DISTINCT AppNUM)

where,

vMaxMonth = month(max(Rep_date)

vMax = max(year)=2016

vPrev=(max(year)-1 = 2015

I need to show month level comparison like am having 2015 and 2016 years and month filter.Am using Combo chart.

Thanks..

[senpradip007]

Sample app would be help you better.

[Anonymous]

What issue you are facing?

[Chanty4u]

what error ur getting?  expression seem correct

[Anonymous]

might be helpful for you?

Comparing Current Month and Previous Month Sales

Month-on-Month comparison

QlikView App: Set Analysis - Prior Period Comparison

[nareshthavidishetty]

When we doing MOM for 2015 and 2016 for FEB-2015 no of days = 28 for 2016 no of days = 29 here i need to compare dynamically. with in one chart

[Anonymous]

Define a month sequence number in your calendar at script like:

     Year * 12 + Month  as MonthNumber (where Year and Month are the respective fields from your calendar)

Then month on month would look something like:

Sum({<MonthNumber ={"$(=Max(MonthNumber ))"}>} Amount)       //For max month

Sum({<MonthNumber ={"$(=Max(MonthNumber )-12)"}>} Amount)   // For Max same month but last year

[nareshthavidishetty]

Ok let me do this and will get back.

Thanks..

[jagan]

HI,

Check this links below

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

Current Month:

Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=MonthStart(Max(Date)))<=$(=Max(Date))’}>} Sales)

Previous Month:

Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=MonthStart(Max(Date), -1))<=$(=MonthEnd(Max(Date), -1))’}>} Sales)

Hope this helps you.

Regards,

Jagan.

[nareshthavidishetty]

Hi Jagan,

I need to compare 2016 vs 2015 mom like 2016 feb vs 2015 feb