Any idea why this cytd-lytd is not working?

[ioannagr]

Hi community,

the expression I created is the following:

sum({1<CurYTDFlag={1}, [year], [month],[filter]*={'something'} >} [total number])-
sum({1<LastYTDFlag={1}, [year], [month],[filter]*={'something'} >} [total number])

It calculates more than the true numbers. What could be going wrong?

[ioannagr]

Actually the mistake is in the second sum about LYTD. 

Also I tried  this logic for LYTD I found in forum (https://community.qlik.com/t5/QlikView-App-Dev/LYTD/td-p/94024) by @sunny_talwar  , like:

 Sum({<[date] = {">=$(=Date(YearStart(Today(), -1)))<=$(=Date(AddYears(Today(), -1)))"},[filter]*=['something']>} [total number])

but, returned 0, which is also not right. Feels like date is not recognized 😱

Please help!