expression with year and month

[#1]

Hi, i have a problem with year.

i need to calculate SALES in December , in the end of the year.

I try to use a lot of expression but qlik don't work.

=sum({<DATA_G={">=$(=yearStart(addmonths(max(DATA_G),-1)))<=$(=yearEnd(addmonths(max(DATA_G),-1)))"}>} SALES)

Thank a lot

[kumarnatarajan]

Hi,

I think you are looking YTD Data. See below syntax.

Ex: =Sum({$<Date={"<=$(=Max(Date))"},Year={"=$(=Max(Year)"},Quarter=,Month=>}SALES)

[#3]

try this

Sum({$<Year=, DATA_G={"<=$(=Max(date(DATA_G)))"}>}SALES)