topic Re: Any wrong in below expression in QlikView

Any wrong in below expression

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

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

Re: Any wrong in below expression

Anil_Babu_Samineni — Thu, 23 Nov 2017 06:43:46 GMT

Can you define the variable?

Re: Any wrong in below expression

qlik4asif — Thu, 23 Nov 2017 06:47:53 GMT

vMaxDate_E2E_Seeds_ProductionCost

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

Re: Any wrong in below expression

Anonymous — Thu, 23 Nov 2017 06:55:50 GMT

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

Re: Any wrong in below expression

Anil_Babu_Samineni — Thu, 23 Nov 2017 06:56:46 GMT

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),'##.###')

Re: Any wrong in below expression

jyothish8807 — Thu, 23 Nov 2017 07:14:21 GMT

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,