topic Re: Sales between months in QlikView

Sales between months

renjithpl — Wed, 19 Dec 2012 05:38:43 GMT

Hi All,

I want to show sales for last 12 months from the current month, i dont have day wise sales instead montly, i have it from 2006,

i used this formula in a straight table

but it shows sales from 2006,

My Current Selection is Year = 2012 and Month = Nov

sum({<MONTH_NAME={">=$(=MonthName(AddMonths(max(MONTH_NAME), -12)))<=$(=MonthName(max(MONTH_NAME)))"}, MONTH_NAME=, Month=, YEAR=, Year=>} Sales)

regards

Re: Sales between months

Wed, 19 Dec 2012 06:34:43 GMT

What is the structure of ur MONTH_NAME field?

Like below or not.

Dec 2011

Dec 2012

~Kabilan K

Re: Sales between months

nirav_bhimani — Wed, 19 Dec 2012 06:46:25 GMT

Hi,

try this

sum ({ <InvoiceDate = P( { <InvoiceDate ={">=$(=(Max(InvoiceDate)-365) ) <= {<CalendarYear={$(=max(CalendarYear))},CalendarMonthName={$(=Month(Max(InvoiceDate)))}>}"}>} ) >} InTotRs)

Regards,

Nirav Bhimani

Re: Sales between months

renjithpl — Wed, 19 Dec 2012 11:28:12 GMT

Hi Kapilan you are right.

Re: Sales between months

Wed, 19 Dec 2012 12:56:24 GMT

So, this expression wont work ryt?

AddMonths(max(MONTH_NAME), -12)

So, u can write a script like this

=sum

({<MONTH_NAME={">=$(=MonthName(AddMonths(makedate(Right(max(MONTH_NAME),4),match(left(max(MONTH_NAME),3),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov,'Dec' )), -12)))<=$(=MonthName(max(MONTH_NAME)))"}, MONTH_NAME=, Month=, YEAR=, Year=>} Sales)

I didn't check this.

just, I assume this.

~kabilan K.