topic Fix constant object loading (hour glass)? in QlikView

Fix constant object loading (hour glass)?

dukane24 — Thu, 14 May 2015 17:52:50 GMT

I have a dashboard with multiple charts and tables, but there is one particular chart that is constantly "reloading". By that I mean it shows an hour glass and a very slow moving progress bar.

What I don't understand is why. This table is not especially complex. It has three simple expressions - the first two are summing amount fields, and the third is to calculate the percentage (compare first amount to second amount). For example:

Expression 1: Sum (Amount_A)

Expression 2: Sum (Amount_B)

Expression 3: "Amount_A"/"Amount_B"

The expressions work, the table calculates correctly, but I don't understand why this particular object is calculating so slowly.

I appreciate any suggestions you may have.

Thanks!

Re: Fix constant object loading (hour glass)?

Anonymous — Thu, 14 May 2015 17:59:56 GMT

A couple of questions :

a) How many rows contained in the table ?

b) What are the dimensions ?

Re: Fix constant object loading (hour glass)?

dukane24 — Thu, 14 May 2015 18:27:26 GMT

Hi Bill,

There are 347k rows. It's a pivot table and the dimensions are Month, Year and Area.

Re: Fix constant object loading (hour glass)?

Anonymous — Thu, 14 May 2015 18:38:55 GMT

How about using a Calculation Condition so that if say more than 10k rows are selected it is not calculated ?

Although 347k rows is not an offensively large amount, but it is way more than a human mind can take in and process.