2 Replies Latest reply: Oct 18, 2014 7:18 PM by Marco Wedel RSS

    Cumulative time graph

      We want to follow the evolution of the customers who had buyed last year and who came back this year until the month we selected.

      We wrote this formula :

       

      Count({< IDC = P({<IDC -= {'0'},  Annee={$(=Max(Annee))}>} IDC)*P({<IDC -= {'0'}, Annee={$(=Max(Annee)-1)}>} IDC)>} distinct IDC)

       

      It work fine.

       

      But, when we put it in a bar graph, we don't have the same result :

      When we select 1 month : OK

      QLIK-PB-STEP1.png

      But, when we select 2 month, the result is wrong in the bar graph :

      The result is false for the last month, and the first month is not good.

      QLIK-PB-STEP2.png

      can somebody help me ?

       

      Thanks.

       

      Regards.