Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
marakud971
New Contributor III

Report Performance

Hi everybody,

I've got an issue about the perfomance of one of my report.
In fact, i've got a lot of rows each days and now my qvd files is bigger and my report is slower.

I 'm looking for a solution to improve my report's performance.
I found in the forum, someone who talked about the use of IF statement.

So I think that i have to change several expression's calculation like my main expression :

=COUNT(DISTINCT (IF (Date = [Date of last operation],CONTRACT_ID)))

How could i write it better ?

And what about other solution to improve the whole performance of my report.

Thanks a lot !

 

2 Replies
jimmygohhanjie
New Contributor III

Re: Report Performance

Hi,

Qlikview computation is rather fast.

I am guessing you have too many charts refreshing at once.

You can check which Object is taking up too much processing.

CTRL + ALT +D to bring up documents settings.  Go to sheet Tab, at the second box, check the Memory usage.

 

if that object (Chart or Pivot table) is taking too much processing. You want to show the object only when User have selected the desired ranges. Example, date range, Departments,  product group.

you can do this at the chart properties--> layout -> show -> Conditional. (GetSelectedCount(Departments) > 0)

 

Support
Support

Re: Report Performance

Well, not sure how much help the following will be, but hopefully may get you on the right track:

Help:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/LoadData/best-p...

Design Blog:

https://community.qlik.com/t5/Qlik-Design-Blog/Data-Modelling-Clarity-vs-Speed/ba-p/1473644

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.