9 Replies Latest reply: Apr 9, 2014 12:13 PM by Nikolaos Kavroulakis RSS

    How to write variables into .qvd

      Hi,

       

      I have 10 expressions calculated from a single table and set to 10 variables. How can I create a QVD from these?

       

      I tried ..

       

      v1 = sum(if(status = 'A',field1));

      v2 = sum(if(status = 'B',field2));

       

      Store v1,v2,.... into x.qvd but it didn't work may be because of using aggregate functions in the expression applied on same table.

       

      Any alternative will be appreciated.

       

      Thank you!

       

       

      regards,

      Rishu