topic Re: How to get the previous month data at the expression level in QlikView

How to get the previous month data at the expression level

Mon, 22 Oct 2012 02:24:06 GMT

Hi ,

I am facing the issue in getting the data for the previous month and i have written the expression as to get the previous month closing inventory qty as current month opening inventory qty but the thing is i am not getting this instead i am getting 0 value

The expression which i have used is as shown below:

For Current Month :

sum({<CalendarMonthID={$(VCurrentCalendarFiscalMonth)}>}inventoryqty)

For Previous Month:

sum({<CalendarMonthID={$(Vcurrentcalendarfiscalmonth-1)}>}inventoryqty)

But still i am not able to get the exact value

Please help me on this as this is urgent.

Regards,

Smita

Re: How to get the previous month data at the expression level

Mon, 22 Oct 2012 03:23:05 GMT

Hi,

Use this in getting the previous month.

Date(AddMonths(Date#(Today(),'YYYY-MM-DD'),-1), 'YYYY-MM-DD')

Regards,

Janzen

Re: How to get the previous month data at the expression level

SunilChauhan — Mon, 22 Oct 2012 06:10:21 GMT

please find Month-Year(Jan-2012) in your application.

if not then calculate from Month

then in expression use below codes

Current Month

sum({<MonthYearField={$(=Date(Max(MonthYearfield),'MMM-YYY'))}>} amountfield)

previous MONTH

sum({<MonthYearField={$(=Date(addmonths(Max(MonthYearfield),-1),'MMM-YYY'))}>} amountfield)

hope this helps

Re: How to get the previous month data at the expression level

Fri, 26 Oct 2012 11:25:24 GMT

thanks for the help ,i will try this and will let you know