What is wrong in expression

[qlik4asif]

Hi All,

please help me in the below expression

=Num(Sum({<Function={'Seeds Ops'},DateMonth={Date(Addmonths(vMaxDate_IIR,-12),'YYYY-MM')}>}YTD),'##.00')

[shraddha_g]

try,

Num(Sum({<Function={'Seeds Ops'},DateMonth={$(=Date(Addmonths(vMaxDate_IIR,-12),'YYYY-MM'))}>}YTD),'##.00')

[Mark_Little]

Hi Asif,

I would probably focus on the section,

Date(Addmonths(vMaxDate_IIR,-12).'YYYY-MM')

Move this into a text box make sure it is returning the correct value. If it is the place it is a variable.

vLastYear_IIR =  Date(Addmonths(vMaxDate_IIR,-12).'YYYY-MM')

Then update your expression

=Num(Sum({<Function={'Seeds Ops'},DateMonth={'$(vLastYear_IIR)'}>}YTD),'##.00')

Mark

[shraddha_g]

Or

Num(Sum({<Function={'Seeds Ops'},DateMonth={$(=Date(Addmonths($(vMaxDate_IIR),-12),'YYYY-MM'))}>}YTD),'##.00')

else

Num(Sum({<Function={'Seeds Ops'},DateMonth={$(=Date(Addmonths($(=vMaxDate_IIR),-12),'YYYY-MM'))}>}YTD),'##.00')

[qlik4asif]

Not working

[qlik4asif]

Not working

[shraddha_g]

try $(vMaxDate_IIR) in Textbox and check whether it is giving correct date value

[sunny_talwar · Accepted solution]

May be this

=Num(Sum({<Function = {'Seeds Ops'}, DateMonth = {"$(=Date(AddMonths(vMaxDate_IIR, -12), 'YYYY-MM'))"}>} YTD), '##.00')

[pradosh_thakur]

'Num(Sum({<Function={'Seeds Ops'},DateMonth={' & Date(Addmonths($(vMaxDate_IIR),-12),'YYYY-MM') & '}>}YTD),'##.00')'

[qlik4asif]

Thanks Sunny

it Solved