Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Partner - Specialist III
Partner - Specialist III

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

Colin-Albert

There are brackets missing

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

amit_saini
Master III
Master III

Try this:

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

Thanks,

AS

sushil353
Master II
Master II

Try this one:

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

HTH

sushil