topic name set to until month in QlikView

name set to until month

ester_pr — Sun, 10 Jul 2011 07:22:06 GMT

Hi,

I need help for creating name set to until mount, I an traing to write the sum of sales until the selected mount with no success

My set is

sum({$<YEAR={2011},month={$(=only(month))}>} ,SALES

I need to make it month <= only(month)

ester_pr — Sun, 10 Jul 2011 09:50:58 GMT

somehow when i write

sum({$<YEAR={only(year-1})}>} ,SALES

it's ok but

sum({$<month={only(month-1})}>} ,SALES

it returns 0, wite the -1 only, way?

rajeshvaswani77 — Sun, 10 Jul 2011 17:46:57 GMT

Hi Ester,

Please use AddMonths(date,-1) and extract the month from it.

Thanks,

Rajesh Vaswani