2 Replies Latest reply: Mar 7, 2013 5:12 PM by Raghu Dubey RSS

    QlikView Variable Expansion in set expression

    Raghu Dubey

      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