Calculation timeout error in pivot table when adding expression having negative value divided by positive value

[ankurakash]

Hi,

I am migrating QlikView dashboard to QlikSense and finding issue with one of the expression in pivot table during migration.

Here, I have couple of dimensions and expressions as part of pivot table. 

Expression, which is causing calculation timeout for the graph is as mentioned below:

Sum(Field A / Field B) ,

Here, Field A has negative values while Field B has positive values (which works fine in QV but fails in QS)

I tried putting the expression like:

Sum(Fabs(Field A)/Field B))  OR Sum(Fabs(Field A / Field B)) however the 'calculation timeout error' is intact.

Requesting solution approach for the above issue.

Thank you.

[Or]

There's no specific issue with dividing by negative values in a pivot table that I've ever encountered. It sounds like there may be an issue with the underlying data model, such as the dimension and measures not all being from properly linked tables.

This super simple demo confirms no native issue:

Load -Rand() as FieldA, Rand() as FieldB, 'A' & Mod(RowNo(),5) as Dimension
Autogenerate 10000;