- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
can expression's results change in time???
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
- Tags:
- new_to_qlikview
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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