topic Report Performance in QlikView

Report Performance

marakud971 — Sat, 16 Nov 2024 03:02:38 GMT

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 !

Re: Report Performance

jimmygohhanjie — Thu, 11 Jul 2019 07:09:41 GMT

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)

Re: Report Performance

Brett_Bleess — Thu, 01 Aug 2019 14:18:47 GMT

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-practices-data-modeling.htm

Design Blog:

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

Regards,
Brett