topic YTD average ???? in QlikView

YTD average ????

amit_saini — Fri, 07 Nov 2014 06:47:37 GMT

Folks,

I'm having an expression named as % Due Eco = count(X)/count(Y) . From this how can I calculate YTD average of % Due Eco for current year only???

Thanks,

jyothish8807 — Fri, 07 Nov 2014 07:07:24 GMT

Hi Amit,

Try this:

Count({<Date={">=$(=Num(YearStart(Max(Date))))<=$(=Max(Date))"}>} X)/Count({<Date={">=$(=Num(YearStart(Max(Date))))<=$(=Max(Date))"}>} Y)

Regards

jyothish8807 — Fri, 07 Nov 2014 07:08:18 GMT

Over here Date is your date field in your application.

Regards

amit_saini — Fri, 07 Nov 2014 07:44:19 GMT

KC you understood it wrong, need to calculate YTD average of the whole expression.

Thanks
AS

jyothish8807 — Fri, 07 Nov 2014 07:53:24 GMT

I guess you mean this:

% Due Eco=Count({<Date={">=$(=Num(YearStart(Max(Date))))<=$(=Max(Date))"}>} X)/Count({<Date={">=$(=Num(YearStart(Max(Date))))<=$(=Max(Date))"}>} Y)