3 Replies Latest reply: Jul 21, 2016 5:06 AM by Andre F. RSS

    How can I autogenerate rows from year total?

    Andre F.

      Hi Community

       

      I am pretty new to Qlikview and need some help.

      I have a table, containing totals per year :

      YearAgentCustomerValue per Year
      2016PaulIBD2000
      2016PaulABC35435
      2016Petersadasds23421
      ....

       

      And I have a table containing a factor per month:

      YearMonthFactor
      2016.010.05
      2016.020.03
      ......
      2016.120.04

       

      Now I want to calculate the proportian per month depending on the factor. to generate a new table with:

       

      YearMonthAgentCustomerValue per Month
      2016.01PaulIBD100 (<---- this is "value per year" * "factor")
      2016.02PaulIBD60
      2016.03..........
      2016.01Petersadasds1171.05
      ......

       

      How can I generate this?

       

      Thank you very much for your help.