topic Re: Re: current month vs last year same month in QlikView

current month vs last year same month

arulsettu — Mon, 29 Sep 2014 07:29:49 GMT

i am showing current month vs last year same month

this code showing current month vs last month

sum({<FiscalPeriod={$(=max(Num(Month(Date(Today()))))),$(=max(Num(Month(Date(Today())))-1))}>}Customer)

i want to make sure the above code is correct and how to get last year same month

thanks

Re: current month vs last year same month

arulsettu — Mon, 29 Sep 2014 07:51:49 GMT

any help?

Re: current month vs last year same month

geert_gelade — Mon, 29 Sep 2014 07:53:03 GMT

For this kind of comparisons, I always calculate a "MonthID" in the script:

(num(Year(Date))-1)*12 + Month(Date) as MonthID

In your expressions you can use afterwards:

Sum({$<MonthID = {$(=Max(MonthID)-12)} >} Amount) for month in previous year

Sum({$<MonthID = {$(=Max(MonthID))} >} Amount) for month in current year

Hope this helps

Re: current month vs last year same month

rubenmarin — Mon, 29 Sep 2014 07:55:44 GMT

That expression executed today will show the sum of the 'Customer' field for Fiscal Period '9' and '8'

Can you upload a sample?

Re: Re: current month vs last year same month

arulsettu — Mon, 29 Sep 2014 08:04:06 GMT

here it is

Re: Re: current month vs last year same month

rubenmarin — Mon, 29 Sep 2014 08:14:16 GMT

Following your expression for month vs month, year vs year should be:

sum({<FiscalYear={$(=max(Num(Year(Date(Today())))-1)), $(=max(Num(Year(Date(Today())))))}, FiscalPeriod={$(=max(Num(Month(Date(Today())))))}>}Customer)

Re: Re: current month vs last year same month

arulsettu — Mon, 29 Sep 2014 08:18:21 GMT

if i want to display current month and last year month in two charts how to split the code?

thanks

Re: Re: current month vs last year same month

arulsettu — Mon, 29 Sep 2014 08:19:34 GMT

it showing current month only

Re: Re: Re: current month vs last year same month

rubenmarin — Mon, 29 Sep 2014 08:53:06 GMT

I'm not sure to understand the requirements.

I made some graphs in attached doc. Hope one of those is what you're searching