16 Replies Latest reply: Jul 31, 2013 12:24 PM by david boston RSS

    Problem with Variable

      Hi All,

       

      New to QV & slowly getting to grips with the syntax for QV expressions and have come across a problem using variables.

       

      I have a variable defined: v_subsect where the value is SUBSECTION_DESC (without an equals) using this in a straight table with a dollar sign $(v_subsect) produces the correct result in that for each line on the table (representing a product) the correct Sub-Section is diplayed.

       

      I have come up against issues trying to use the variable in a set analysis within the same straight table.

       

      for example to give the total revenue for the sub-section a product belongs to I tried:

       

      sum({<SUBSECTION_DESC=$(v_subsect)>}revenue)

       

      OR

       

      sum({<SUBSECTION_DESC={$(v_subsect)}>}revenue)

       

       

      neither of which produced a value at all.

       

      Does anybody have any ideas as to where I am going wrong??

       

      Thanks

       

       

      PS - whilst I understand sharing the QV would be helpful, unfortunately I cannot do so due to business restrictions!