Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

niccolo24
New Contributor II

Variable in set analysis

Hi

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)

Tx

4 Replies
jpenuliar
Valued Contributor III

Re: Variable in set analysis

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

Re: Variable in set analysis

There are brackets missing

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

amit_saini
Honored Contributor III

Re: Variable in set analysis

Try this:

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

Thanks,

AS

sushil353
Honored Contributor II

Re: Variable in set analysis

Try this one:

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

HTH

sushil

Community Browser