topic Re: YTD consumed days in QlikView

YTD consumed days

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

I am trying to get the value of Year to Date consumed work days, with holidays into a table.

Count({$<Year_BV = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,(vHolidaysBV))))"}>}

distinct [Date Bioventus]) -1

This formula works in a text box, but returns a 0 within the table. Any ideas?

**The correct return should be 160 days consumed

sunny_talwar — Mon, 28 Aug 2017 16:49:07 GMT

What value do you expect to see for this in the table?

joshrussin — Mon, 28 Aug 2017 16:51:35 GMT

160

sunny_talwar — Mon, 28 Aug 2017 16:53:59 GMT

This gives 160

Count(TOTAL {$<Year_BV = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,(vHolidaysBV))))"}>}

distinct [Date Bioventus]) -1