Any wrong in below expression

[qlik4asif]

Hi All,

The below expression is ok , but i am getting zero value,

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

I have checked

Yearstart(vMaxDate_E2E_Seeds_ProductionCost)

YearEnd(vMaxDate_E2E_Seeds_ProductionCost)

Both are getting dates, but the whole expression is not getting value

Thanks in advance

[Anil_Babu_Samineni]

Can you define the variable?

[qlik4asif]

vMaxDate_E2E_Seeds_ProductionCost

=Max({<KPI1={'E2E Seeds Production Cost'},YTD={">0"}> + <KPI1={'E2E Seeds Production Cost'},YTD={"<0"}>}DateMonth)

[Anonymous]

Hi,

What is the format of the DateMonth field? Is it in Date format(e.g 'DD/MM/YYYY') or in MonthYear format(e.g. MM/YYYY) ?

I think it should be in Date format according to this expression to work.

Thanks,

Harshit

[Anil_Babu_Samineni]

If below one is working for you

Num(Sum({<DateMonth={">=$(=Yearstart(Max({<KPI1={'E2E Seeds Production Cost'},YTD={">0"}> + <KPI1={'E2E Seeds Production Cost'},YTD={"<0"}>}DateMonth)))<=$(=YearEnd(Max({<KPI1={'E2E Seeds Production Cost'},YTD={">0"}> + <KPI1={'E2E Seeds Production Cost'},YTD={"<0"}>}DateMonth)))"}>}BUD),'##.###')

Then, It should work with variables using this?

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

[jyothish8807]

Hi Asif,

Can you check if the format of DateMonth and both varibales are same ? This could be because of mis match of date format.

BR,

KC