Qlikview tab showing blank screen

[muthukumarbalu]

Hello experts,

My Qlikview dashboard has around 10 tabs and it's QVW size is about 200+ MB. Recently one of 10 tab is not opening when it is fully reloaded. After some time it showing Lost connection to server. PFA.

Note the same tab is working fine when it has loaded with some limited load (top 10000) .

Kindly advise me, how to overcome this issue and Where can i see the actual error like log files.

Thanks in advance.

Best Regards,

Muthukumar Balu

[YoussefBelloum]

how much users you have and how much RAM do you have on the server ?

[HirisH_V7]

Hi,

Try using Calculation Condition,

If you have a lot of objects displayed in one tab, Qlikview will calculate all objects and it could be lead to performance problems.

In Settings / Sheet Properties / Objects, you can see the time calculation of each object.

Create one variable for each sheet vSheet1,vSheet2 so on etc.,

Then in activate sheet(vSheet1=1) and leave sheet(vSheet1=0) , Similarly for all sheets.

use the same condition as    =vSheet1=1   in Caluculation Condition for all objects in the particular sheet.

This will help to improve performance of app, as other sheets & their corresponding objects will not be active at one time.

PFA

HTH,

Hirish

[Peter_Cammaert · Accepted solution]

The QlikView server will not endlessly recalculate large objects. It has a few settings that determine when to abort those calculations (default is 60 secs) which are in many cases running for an excessive amount of time because of bad usage of resources. Keep in mind that QlikView should target response times of a few seconds at the max, or the end-user may become bored with the product...

Aside from the better solution (Calculation Condition) that was suggested before, there are a few other options to consider:

• If you use complex calculations in the objects on the malfunctioning sheet, you may want to consider an optimization session to improve performance by better usage of resources.
• If you feel that the calculation time should be increased because the document cannot be optimized any further and the end-user must be allowed to see the end result without any further selections, consider increasing the Object Calculation Time Limit in QMC (see System > Setup > QlikView Server > Performance > Object Calculation Time Limit).
  But keep in mind that this Time Limit is already multiplied by the number of cores before being applied.
  Also keep in mind that the Calculation Limit may become longer than the Session Timeout, which may throw you off the server before the object has finished recalculating... Very bad for server performance

Best,

Peter

[muthukumarbalu]

10 users and server RAM is 32 GB

[muthukumarbalu]

Let we try this..

[muthukumarbalu]

Hi All,

The issue has been sorted out now.

Root cause: Complex expression (If with or condition) has created many loops, which result in server timeout.

Solution: Complex expression scenario handled in ETL part. And the tab is launching now.

Best Regards,

Muthukumar Balu