topic Re: expression with year and month in QlikView

expression with year and month

Mon, 17 Jun 2013 07:34:35 GMT

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 — Mon, 17 Jun 2013 07:41:00 GMT

Hi,

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

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

Mon, 17 Jun 2013 07:49:21 GMT

try this

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