QlikView Variable Expansion in set expression

[#1]

HI All,

I have a variable that calculated correctly and I verified it using a text box.

I want to use the value of this variable in the below set expression:

='$'&NUM(ROUND(SUM({$<calendar_date_num = , business_date_num = {'$(=vMaxBusinessDate)'}>} '$(=vDerivedName)'),'###,###,###,###')

OR

='$'&NUM(ROUND(SUM({$<calendar_date_num = , business_date_num = {'$(=vMaxBusinessDate)'}>} {<$(=vDerivedName)>}),'###,###,###,###')

To explain it in other words, what I am trying to do is in a set expression like SUM({<Year=2007>}sales), I am trying to dynamically change the 'sales' field based on the value of a variable. Would be great is someone can help me on this issue. Am I messing up with syntax?

Thanks

Raghu

[#2 · Accepted solution]

If vDerivedName evaluates to a field name then use SUM({$<calendar_date_num = , business_date_num = {'$(=vMaxBusinessDate)'}>} $(=vDerivedName))

[#3]

Hey..thanks.

I was able to figure out the solution. And its exactly the same as you mentioned above. I was also missing a date format.

Thanks

Raghu