The request exceeds the memory limit

[tuan_nguyen]

I have some issue when load data.

when i load data with date condition this make exceeds the memory limit but when i change condition then there is no such error

This is dimensions field(image 2)

Thanks

[vinieme12]

The main message here is QlikSense is running out of Ram  trying to calculate this

2 important factors you need to work on

1) Simplify your data model 

2)Simplify your expression

[tuan_nguyen]

Hi,

I check my expression, when i try only like "If(len(FromDate) > 0, [users.id])"  but but will get the error as shown in the picture and have to refresh continuously

[vinieme12]

best to create this as a new field  while loading the data as below

,If(len(FromDate) > 0, [users.id]) as NewUserIdField

OR

in chart  you can also try 

Aggr(   If(len(FromDate) > 0, [users.id]) , [users.id])