6 Replies Latest reply: Apr 7, 2015 7:55 AM by Timanshu Virmani RSS

    How to pass column() value to an Expression with set analysis

      Hi, i'm new in QV and i need do this:

       

      Im loading a table inline with 3 fields

       

      Cuenta:

      LOAD * INLINE [

          IdCuen, NombreCuen, Valor

          1, Val1, 10

          2, Val2, 20

          3, Val3, 30

      ];

       

      When i working with a pivot table, im creating an expression with the value of the Valor Field. So, i need to pass this value to a second expression wih set analysis like this:

       

      Sum({<[Cuenta N3] = {$(=Column(1))}>} MOVIMIENTO)

       

      but not working.

      What im doing wrong??

       

      I know that do the expression like Sum({<[Cuenta N3] = {$(=10)}>} MOVIMIENTO) its easy, but im trying to do more generic, load data from script.

       

       

       

      Thanks