0 Replies Latest reply: Jul 26, 2017 8:26 AM by John Lewis RSS

    Qlik Sense Calculation with Missing Data

    John Lewis

      I recently posted an issue I was having with missing data, and received a solution for it.  However, I am having a similar issue and am unable to resolve it.

       

      The original issue is documented in this post:

       

      Qlik Sense Calculation with Missing Data

       

      The issue I am having now is similar, but not the same.  Originally, I was having a problem with a restaurant that has missing current week sales, but sales exists for the prior 4 weeks, and I received a solution for that.  Now, the issue is with a restaurant that has current week sales, but is missing sales for the prior 4 weeks.  I tried to implement the solution for the original problem, but I am not able to get it to work in this case.

       

      Here is an illustration of the problem:

       

           

      RestaurantSalesTrailing 4 WeeksGrowth %
      (Incorrect)
      Sales for Calc (Correct)Trailing 4 Weeks for Calc (Correct)Growth %
      (Correct)
      1500549.25-9.0%500549.25-9.0%
      20615.25N/A00N/A
      3546480.2513.7%546480.2513.7%
      4845698.2521.0%845698.2521.0%
      55550N/A00N/A
      Total611.50585.754.4%630.333333575.929.4%


      In the above example, the original issue was with Restaurant 2.  I have a similar issue with Restaurant 5.  Both of these restaurants should not be included in the Total calculation.  The correct Growth % is 9.4%, not the 4.4% that is being calculated currently.

       

      I have attached the original app updated with the Restaurant 5 example.  Can someone help provide me with how I can calculate the total Growth % without including Restaurants 2 and 5?