topic Re: Set analysis MOM in QlikView

Set analysis MOM

nareshthavidishetty — Tue, 23 Feb 2016 06:05:24 GMT

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..

Re: Set analysis MOM

senpradip007 — Tue, 23 Feb 2016 06:08:13 GMT

Sample app would be help you better.

Re: Set analysis MOM

Anonymous — Tue, 23 Feb 2016 06:08:56 GMT

What issue you are facing?

Re: Set analysis MOM

Chanty4u — Tue, 23 Feb 2016 06:09:16 GMT

what error ur getting? expression seem correct

Re: Set analysis MOM

Anonymous — Tue, 23 Feb 2016 06:11:03 GMT

might be helpful for you?

Comparing Current Month and Previous Month Sales

Month-on-Month comparison

QlikView App: Set Analysis - Prior Period Comparison

Re: Set analysis MOM

nareshthavidishetty — Tue, 23 Feb 2016 06:21:11 GMT

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

Re: Set analysis MOM

Anonymous — Tue, 23 Feb 2016 06:26:53 GMT

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

Re: Set analysis MOM

nareshthavidishetty — Tue, 23 Feb 2016 06:31:33 GMT

Ok let me do this and will get back.

Thanks..

Re: Set analysis MOM

jagan — Tue, 23 Feb 2016 06:53:40 GMT

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.

Re: Set analysis MOM

nareshthavidishetty — Tue, 23 Feb 2016 08:16:19 GMT

Hi Jagan,

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

Re: Set analysis MOM

jagan — Tue, 23 Feb 2016 08:21:34 GMT

Try like this

Current Month:

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

Previous Year Same Month:

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

Hope this helps you.

Regards,

jagan.

Re: Set analysis MOM

Anonymous — Tue, 23 Feb 2016 08:21:48 GMT

Did you try what I suggested you?

Re: Set analysis MOM

PrashantSangle — Tue, 23 Feb 2016 08:26:50 GMT

Hi,

need little change in second expression suggested by JAgan

try below

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

or you can use addYears()

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

Regards

Re: Set analysis MOM

nareshthavidishetty — Tue, 23 Feb 2016 09:51:21 GMT

Thanks to all the issue got resolved.

Re: Set analysis MOM

Anonymous — Tue, 23 Feb 2016 09:53:31 GMT

Dont forget to close this thread by selecting correct/helpful answer