11 Replies Latest reply: Aug 7, 2014 4:25 AM by Benjamin HOUOT RSS

    How to create a cumulative percentage by month ?

      Hi everyone,

       

      This is my first post on the qlik community

       

      I try to have the percentage of buyers of a product vs a set of product ({<Product=p(ProductParent)>}) cumulative by month

       

      if it was not cumulative, i could use this function. : =sum(buyer)/sum({<Product=p(ProductParent)>}buyer)

       

       

      Exemple with only 2 Months

      January : 3 buyers vs 5 in total

      February : 7 buyers vs 15 in total

       

      i would like to have a table with

      January 60% (3/5)

      February 50% ((3+7)/(5+15))

       

      At the end, i should be able to select any range of Months.

      Do you have an Idea how to proceed ?

       

      For information:

      I put Month variable in Dimension of my table but i don't think is a good idea.

      I try to modify SetExpression but it seems it applies to all the table and not just on the Month category.

       

      I can't create all possibilitites of cumulative Months

      But maybe can I create a calculated dimension which represents cumulative Month ? ==> but i don't know how to proceed

       

       

      Thank you for your answers.