topic Re: QlikView Variable Expansion in set expression in QlikView

QlikView Variable Expansion in set expression

Thu, 07 Mar 2013 21:14:31 GMT

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)'),'###,###,###,###')

='$'&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

Re: QlikView Variable Expansion in set expression

Thu, 07 Mar 2013 22:10:02 GMT

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

Re: QlikView Variable Expansion in set expression

Thu, 07 Mar 2013 22:12:41 GMT

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