Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How does In Memory Works in Qlikview?

Hi,

I am having problems with the processing time.

the move to a tab operation is effected in all the data, which takes on average 20 seconds without applying any filter time, over a period of 3 years with 1 million rows.

my question is that by restricting the filter to 30 days in a specific year, takes the same amount of time.

QV will always covers all fields?

should not be as ralacionales data base, applying a WHERE operations are not performed with the indicated results and do not compared with other rows

PD: my date field is ordered.

Screenshot_22.png

Screenshot_1.png

2 Replies
Clever_Anjos
Employee
Employee

It depends of many aspects

  • You expressions
  • How your data is related
  • What´s the  frequency of your data.

It would be easier if you post a sample of your APP

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

A smaller amount of selected data should take less time to process. So my guess is you have an improperly written expression or are doing something with a data island. Can you post your app, or at least the chart expressions?

-Rob