14 Replies Latest reply: Apr 24, 2017 3:03 AM by Mahendra Gaur RSS

    Variable manipulation

    Mahendra Gaur

      Hello,

       

      I want to get the final output based on multiplication of variables and a column(Value) of a pivot in QlikView. Below is my requirement-

       

      Variables-

         

      Variables
      A20
      B50
      C30
      D60

       

       

      Current Pivot Chart-

       

         

      NameValue
      A10
      B20
      C3
      D40
      E100
      F60

       

      Expected Pivot Chart-

       

         

      NameValue
      A200
      B1000
      C90
      D2400
      E100
      F60