Data in Qlik Pivot/Hypercube is totaling incorrectly in Published App

[cmick]

We are currently seeing a Qlik Hypercube aggregate and total data incorrectly in a Published Qlik Application (Published only). The odd thing is that the data will be correct after reload but over time the totals and aggregates will start to increase in size. Reloading the App seems to resolve/reset the issue but this is not a good solution as we need to understand what is causing the totals to vary.

Some interesting scenarios are that once the published application totals become bad, they are bad for all users of the published app, and copying the published app to a private workstream resets the totals, and it is not seen in the non-published versions of the application. The scenario being calculated is a “full outer join” on two island fact tables (we

believe this may be contributing to the issue, but the results are inconsistent). We have seen the erroneous calculation totals in the pivot and straight tables.

Formula for Measure:

num(if('$(Over_Under_Summary_Type)'='Period', 

sum({1<Period={'$(Over_Under_Month)'}>} if(%BoIT_ServiceSkey=%ServiceSkey,BOITCharges,0)),

 sum({1<FiscalYear={$(=$(vYear('$(Over_Under_Month)')))},Period={"<=$(Over_Under_Month)"}>} if(%BoIT_ServiceSkey=%ServiceSkey,BOITCharges,0)) ), '$#,##0;($#,##0)')

[NadiaB]

Hi @cmick 

Support usually don't analyze formulas or Data Models, this because it could take a bit analyze/debug the Data Model and the formula. 

I was wondering if this app has any partial reload ? Maybe a different task was created for that purpose, has it be verified that indeed there is nothing changing data in the app ? 

Could it be possible to create a copy of the app and publish it and verify if the new published app present the same behavior ? 

When you see the different in the calculation/numbers, have you for example verified that underlying data shows different values (something that tells the calculation is incorrect)? 

When the numbers are unexpected, has it been verified that if there any filters applied, all the filters are the same when comparing information ? 

If you create a sample app with same structure of the Data Model but reduce data, are you able to reproduce ? 

Kind Regards,