topic Re: What is wrong in expression in QlikView

What is wrong in expression

qlik4asif — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

please help me in the below expression

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

Re: What is wrong in expression

shraddha_g — Wed, 22 Nov 2017 11:18:09 GMT

try,

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

Re: What is wrong in expression

Mark_Little — Wed, 22 Nov 2017 11:32:52 GMT

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

Re: What is wrong in expression

shraddha_g — Wed, 22 Nov 2017 11:34:34 GMT

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')

Re: What is wrong in expression

qlik4asif — Wed, 22 Nov 2017 11:50:56 GMT

Not working

Re: What is wrong in expression

qlik4asif — Wed, 22 Nov 2017 11:51:08 GMT

Not working

Re: What is wrong in expression

shraddha_g — Wed, 22 Nov 2017 11:52:47 GMT

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

Re: What is wrong in expression

sunny_talwar — Wed, 22 Nov 2017 12:57:57 GMT

May be this

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

Re: What is wrong in expression

pradosh_thakur — Wed, 22 Nov 2017 13:32:17 GMT

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

Re: What is wrong in expression

qlik4asif — Wed, 22 Nov 2017 14:08:08 GMT

Thanks Sunny

it Solved

Re: What is wrong in expression

qlik4asif — Thu, 23 Nov 2017 06:25:18 GMT

Hi Sunny,

Could you please find the error for the below expression

=Num(Sum({<DateMonth={">=$(=Yearstart(vMaxDate_E2E_Seeds_ProductionCost))<=$(=YearEnd(vMaxDate_E2E_Seeds_ProductionCost))"}>}BUD),'##.###')

Re: What is wrong in expression

Anil_Babu_Samineni — Thu, 23 Nov 2017 06:27:31 GMT

May be

=Num(Sum({<DateMonth={">=$(=Yearstart($(vMaxDate_E2E_Seeds_ProductionCost)))<=$(=YearEnd($(vMaxDate_E2E_Seeds_ProductionCost)))"}>}BUD),'##.###')

Re: What is wrong in expression

qlik4asif — Thu, 23 Nov 2017 06:32:55 GMT

Thanks Anil for the reply

But its not working

Re: What is wrong in expression

Anil_Babu_Samineni — Thu, 23 Nov 2017 06:35:26 GMT

May be with equal sign

=Num(Sum({<DateMonth={">=$(=Yearstart($(=vMaxDate_E2E_Seeds_ProductionCost)))<=$(=YearEnd($(=vMaxDate_E2E_Seeds_ProductionCost)))"}>}BUD),'##.###')

can you describe how you define the variables if none of them working

Re: What is wrong in expression

shraddha_g — Thu, 23 Nov 2017 07:25:36 GMT

Try

Num(Sum({<DateMonth={">=$(=Date(Yearstart($(vMaxDate_E2E_Seeds_ProductionCost)),'YYYY-MM'))<=$(=date(YearEnd($(vMaxDate_E2E_Seeds_ProductionCost)),'YYYY-MM'))"}>}BUD),'##.###')

Re: What is wrong in expression

sunny_talwar — Thu, 23 Nov 2017 23:21:33 GMT

Or this

=Num(Sum({<DateMonth = {">=$(=Date(Yearstart(vMaxDate_E2E_Seeds_ProductionCost), 'YYYY-MM'))<=$(=Date(YearEnd(vMaxDate_E2E_Seeds_ProductionCost), 'YYYY-MM'))"}>}BUD), '##.###')