can expression's results change in time???

[Anonymous]

Hi community,

in my document I'm using expressions with various levels of aggregation. These expressions depend on a field of IDs and I'm facing this kind of situation:

if I select the ID=3, the expression return 100, then I choose ID=2 and the result is 0, then I select again ID=3 and the result becomes 0!!!

In the expression there's no changing of variables which could cause such a difference... The aggregations are complex and I think they could be the cause of this event...

I try attach you one...

Thanks to everyone's going to look at that...

Bye

IB

[parthiband]

Hi Irene,

It will be better if u attach a sample file with few/dummy data.

So that we can be able understand the objective and validate the data.

Thanks,

[Anonymous · Accepted solution]

I've found out it was a problem concerning RAM usage. The expressions used where many and complex so Qlik seemed to stop at a certain high level of RAM usage and return a partial result.

The only way to resolve this problem is, in general, to have a look at the expressions in order to simplify them or memorize the expressions in variables if repeated.

IB