Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
john_lewis
New Contributor

Qlik Sense Calculation with Missing Data

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?