topic InYearToDate function - can it be used within Set Analysis in QlikView

InYearToDate function - can it be used within Set Analysis

hansdevr — Sat, 16 Nov 2024 21:48:35 GMT

Dear Specialists,

To determine YTD sums, up to now I used

sum ({$<Boekdatum = {"<=$(=Max(Boekdatum))>=$(=Yearstart(Max(Boekdatum)))"}>}Betalingen)

Is there some way of incorporating the InYearToDate() function, so I can easily compare the YTD sum with same sum in previous book year (up till Max(Boekdatum)-1 year)?

Help would be much appreciated!

Regards,

Hans

Re: InYearToDate function - can it be used within Set Analysis

sunny_talwar — Thu, 29 Nov 2018 12:50:37 GMT

Have you tried this for the previous year?

Sum({$<Boekdatum = {">=$(=YearStart(Max(Boekdatum), -1))<=$(=AddYears(Max(Boekdatum), -1))"}>} Betalingen)

Re: InYearToDate function - can it be used within Set Analysis

hopkinsc — Thu, 29 Nov 2018 16:33:37 GMT

Hi Hans,

You can use InYearToDate() in set analysis like this..

{< Boekdatum = {"=InYearToDate(Boekdatum, Today(), 0)", "=InYearToDate(Boekdatum, Today(), -1)"} >}

Does that help?