topic Addmonths issue in chart in QlikView

Addmonths issue in chart

Kushal_Chawda — Mon, 05 Aug 2013 08:58:32 GMT

Hi,

I am facing issue with addmonths fucntion.

I have chart having dimension Product & product group. I want to show opening balance as closing of prev month.

I am using expression as sum({<MonthYear = {'$(=addmonths(MonthYear,-1))'}>} Amount) but its not working..

Please help me out to write the expression for getting previous month amount

Re: Addmonths issue in chart

CELAMBARASAN — Mon, 05 Aug 2013 09:04:17 GMT

How your are creating MonthYear field?

Month(Date)& Year(Date) or using MonthName function?

Celambarasan

Re: Addmonths issue in chart

Kushal_Chawda — Mon, 05 Aug 2013 09:15:59 GMT

Hi,

I am using monthname function..

For testing purpose when I am writing expression: addmonths(Monthyear,-1) in text object. I am selecting year 2013 month Apr then getting Mar 2013.. So MonthYear field is proper.

Re: Addmonths issue in chart

Kushal_Chawda — Mon, 05 Aug 2013 09:25:01 GMT

Hi,

Got the answer..

sum({<MonthYear= {'=AddMonths(MonthYear,-1)'}>}Amount).. not required $