topic Re: Calculate LMTD Sales. in QlikView

Calculate LMTD Sales.

Fri, 03 Jan 2014 09:10:47 GMT

Hi Folks,

Wish u Happy New Year 2014 to Every one.

I want to Calculate Last month till date means. If I Select Jan-2014. I want to Calculate 01-Dec-2013 to 02-Dec-2013.

The Field Values are CalendarDate, CalendarMonth, CalendarYear, GrossAmt as Sale amount

Thanks and Regards,

Sakthivel.S

Re: Calculate LMTD Sales.

jagan — Fri, 03 Jan 2014 09:26:58 GMT

Hi,

Try this expression

=Sum({<CalendarDate={'>=$(=MonthStart(Today(), -1))<$(=Today())'}, CalendarMonth=, CalendarYear=>} [Sale amount])

Hope this helps you.

Regards,

Jagan.

Re: Calculate LMTD Sales.

Fri, 03 Jan 2014 10:16:27 GMT

Hi Jegan,

Thanks for your response. But the result showing if i select Jan 2013 . It Shows 01-Dec-2013 to 03-Dec-2013. But i am asking to Select Jan 2014 . it should show 01-Dec-2013 to 03-Dec-2013

Regards,

Sakthivel

Re: Calculate LMTD Sales.

Fri, 03 Jan 2014 10:31:17 GMT

=Sum({<CalendarDate={'>=$(=MonthStart(Today(), -1))<$(=Today())'}>} [Sale amount])

use this ..

Re: Calculate LMTD Sales.

tresB — Fri, 03 Jan 2014 10:38:11 GMT

Could you post a sample app?

Re: Calculate LMTD Sales.

miikkaqlick — Fri, 03 Jan 2014 10:59:07 GMT

Try this:

=Sum(

CalendarDate={'>=$(=MonthStart(Addmonths(Today(),-1)))<$(=AddMonths(Today(),-1))'},

CalendarMonth=,

CalendarYear=

[Sale amount])

Br,

Miikka

Re: Calculate LMTD Sales.

Fri, 03 Jan 2014 12:01:34 GMT

Dear Friends,

Thanks you all for response

Correct Answer : =Sum({< CalendarYear=, CalendarMonth=, CalendarDate={'>=$(=MonthStart(Max(CalendarDate), -1))<=$(=MonthEnd(Max(CalendarDate), -1))'} [Gross amt])