topic QlikView performance issue in QlikView

QlikView performance issue

shyamcharan — Wed, 29 Apr 2015 01:48:01 GMT

Hi Experts,

I have performance issues with my dashboard. We are currently having huge number of records(in Millions) and due to that the dashboard does not load properly.

Could you please suggest the best approach to resolve this performance issue.

Please suggest the areas that I need make the tuning or settings.

It looks like in future the client data would grow immensely but how can I get the dashboard ready for that.

Sorry to tag this message but we are moving to production and this issue is kind of stopping it.

Any help and suggestions on this is highly appreciated.

Regards,

Shyam.

Re: QlikView performance issue

Wed, 29 Apr 2015 04:59:13 GMT

Hello,

If it is possible in your case, try to set dimensions limits on all tables(pivot or regular).

Best Regards!

Re: QlikView performance issue

NareshGuntur — Wed, 29 Apr 2015 05:12:09 GMT

Try to apply some selection(on open trigger) like latest year and latest quarter so that the calculations will be faster.
Try minimizing some of the objects so that minimized objects will be calculated only when they are active
Check your expressions and try making them simple wherever possible. Try to use flags.
Check if you have nested ifs in the expressions.
HOPE YOUR SYSTEM HAS ENOUGH CONFIGURATION TO HOLD BIG AMOUNT OF DATA

Cheers,

Naresh

Re: QlikView performance issue

vishsaggi — Wed, 29 Apr 2015 07:08:48 GMT

Helly Shyam,

Check this link you will get little more information. Though It is an old post but worth reading.

*** 6 Weeks in to QV Development, 30 Million Records QV Document and Help Needed!!! ****

Regards,
V.