topic Variable in set analysis in QlikView

Variable in set analysis

Anonymous — Mon, 01 Dec 2014 10:42:24 GMT

can someone help me in understanding what is wrong with this expression?? I am having trouble with the vToday variable:

=sum({<DTA_MAKEDATE= {'$(=Date(monthname($vToday,-1),'MM/YYYY'))'}>} PDT_DBL_AUM)

jpenuliar — Mon, 01 Dec 2014 10:45:18 GMT

try enclosing your variable with (), $(vToday)

Colin-Albert — Mon, 01 Dec 2014 10:46:24 GMT

There are brackets missing

=sum({<DTA_MAKEDATE= {'$(=Date(monthname($(vToday), -1),'MM/YYYY'))'}>} PDT_DBL_AUM)

amit_saini — Mon, 01 Dec 2014 10:46:42 GMT

Try this:

=sum({<DTA_MAKEDATE= {'$(=Date(monthname($(=vToday,-1)),'MM/YYYY'))'}>} PDT_DBL_AUM)

Thanks,

sushil353 — Mon, 01 Dec 2014 10:46:48 GMT

Try this one:

=Sum({<DTA_MAKEDATE = {'$(=Date(monthname($(vToday,-1)),'MM/YYYY'))'}>} PDT_DBL_AUM)

HTH

sushil