topic Re: Last 3 Months Sales? in QlikView

Last 3 Months Sales?

khadeer — Thu, 28 Mar 2013 06:41:33 GMT

Hi All,

I have to show last 3 months Sales data without reflecting any selections in same table respective of product....

my date field is posting date in YYYY-MM-DD format?

Please help me how i can achive this?

Re: Last 3 Months Sales?

nirav_bhimani — Thu, 28 Mar 2013 06:44:28 GMT

Hi,

Try this Expression.

=Sum({<CalDate={'>=$(=MonthStart(Max(CalDate), -2))<=$(=MonthEnd(Max(CalDate)))'}, CalMonth=,CalQuarter=,CalYear= , CalMonthYear= >} Sales)

Regards,

Nirav Bhimani

Re: Last 3 Months Sales?

nirav_bhimani — Thu, 28 Mar 2013 06:54:15 GMT

HI ,

See the attachment

Output as per your requirement.

EXP:

=Sum({< CalDate={'>=$(=MonthStart(Max( {<CalYear=, CalMonth= , CalMonthYear=, CalQuarter=>} CalDate), -2))<=$(=MonthEnd(Max( {<CalYear=, CalMonth= , CalMonthYear=, CalQuarter=>} CalDate)))'} , CalMonth=,CalQuarter=,CalYear= , CalMonthYear= >} Sales)

Reagrds,

Nirav Bhimani

Re: Last 3 Months Sales?

khadeer — Thu, 28 Mar 2013 09:49:34 GMT

Hi Nirav,

Thanx for ur reply....

I am not getting correct answer by that expression. I have to get last 3 months sales expect this month means for present it is march so i have to show dec-12, jan-13,feb-13...... it doen't effect to my selection, suppose if i am seeing 2012 may data ... that data will be constanat..... for every selection

Regards,

Khadeer

Re: Last 3 Months Sales?

nirav_bhimani — Thu, 28 Mar 2013 11:03:18 GMT

Hi,

Try this updated exp:

=Sum({< CalDate={'>=$(=MonthStart(Max( {<CalYear=, CalMonth= , CalMonthYear=, CalQuarter=>} CalDate), -3))<=$(=MonthEnd(Max( {<CalYear=, CalMonth= , CalMonthYear=, CalQuarter=>} CalDate), -1))'} , CalMonth=,CalQuarter=,CalYear= , CalMonthYear= >} Sales)

Regards,

Nirav Bhimani

Re: Last 3 Months Sales?

nizamsha — Thu, 28 Mar 2013 11:25:45 GMT

=sum({$<Month={">=$(=Max(Month)-3)<$(=Max(Month))"},Day=,Year={"2008"}>}[Sales Amount])

use this one it will help i think

Re: Last 3 Months Sales?

nizamsha — Thu, 28 Mar 2013 11:30:24 GMT

u can nullify the year too this will work

Re: Last 3 Months Sales?

Thu, 28 Mar 2013 11:38:22 GMT

Hi,

Nirbav post is correct that will gives you output as expected, but small change in it i.e; to avoid present month data

=Sum({< CalDate={'>=$(=MonthStart(Max( {<CalYear=, CalMonth= , CalMonthYear=, CalQuarter=>} CalDate), -3))<=$(=MonthEnd(Max( {<CalYear=, CalMonth= , CalMonthYear=, CalQuarter=>} CalDate),-1))'} , CalMonth=,CalQuarter=,CalYear= , CalMonthYear= >} Sales)

Best of luck