Stright table is taking more time to show up data in Qlikview Report while opening?

[siva_boggarapu]

Hello Everyone,

I have stright table in my Qlikview Report. When I am opening the report its talking more time to show data in the chart. How can i increase the performance of the chart?

I would Appreciate, if anyone give reply to this. This is very urgent.

Best,

Siva.

[jagan]

Hi Siva,

First check your expressions, check whether there are lot of calculations involved in expressions.  If so, try to avoid those by calculating in script while loading. 

Secondly, check how many records you are displaying, if you are displaying huge amount of data, restrict user by selecting any filters.

Hope this helps you.

Regards,

Jagan.

[goldnejea8]

You could also have a calculation condition in which the table would only calculate when a user selects different fields.  That, coupled with Jagan's idea would make for a far better user experience

[Sokkorn]

Hi Siva,

Just want to add more on Jagan's idea post.

a. Always use set analysis for each expression.

b. Check your data model.

     1. Fact Table and Dimension Table

     2. Load Data from source ==> QVD ==> transform QVD ==> QVD end result.

c. Avoid disconnect table.

d. Remove unwanted field.

Regards,

Sokkorn

[siva_boggarapu]

Hello Everyone,

Thank you so much for all your replyes.

Best,

Siva.