13 Month trend Question

Wed, 24 Aug 2011 19:51:01 GMT

I am trying to create a bar graph showing a 13 month trend, but I can only get 12 months to appear. The problem I am having is getting a month from say 2010 to show up on the chart when 2011 is the main sort. I know Year=, will deselect year but I tried to go one step further and command it to select 2010 to show up. Still nothing shows up from prior year. Any advice would be appreciated. The formula below is what I am using where it sets year to 2010, scenario and acctlvl are irrelevant, and MonthYearCount is an associated table to Month which gives the most recent month a set value say 60 and NatAMT is the dollar Value.

=if(num(Month)>$(vMonth),-1*(Sum({$<Year={2010},SCENARIO = {FCST005},ACCT_LVL10 = {'Revenues (L1)'},MonthYearCount={$(=Max(MonthYearCount)-12)}>} NAT_AMT))/$(vScale),

-1*(Sum({$<Year={2010},SCENARIO = {ACTUALS},ACCT_LVL10 = {'Revenues (L1)'},MonthYearCount={$(=Max(MonthYearCount)-12)}>} NAT_AMT))/$(vScale))

Thanks,

Craig

13 Month trend Question

klausskalts — Thu, 25 Aug 2011 14:02:18 GMT

I suggets that you create a unique Year_Month field e.g.

Date(Monthstart(Datefield), 'YYYY-MMM')

and/or use the addmonth-command to select directly in your Set-analysis formula.

Re: 13 Month trend Question

SunilChauhan — Thu, 25 Aug 2011 14:13:42 GMT

please see the attched file

hope this helps u

13 Month trend Question

Thu, 25 Aug 2011 15:34:23 GMT

This worked really well!!!!

Thanks for all the help!

topic 13 Month trend Question in QlikView

13 Month trend Question

13 Month trend Question

Re: 13 Month trend Question

13 Month trend Question