Qlikview performance issue

[#1]

I am sumanta kr.Mandal working in qlikview tool.Recently I am facing performance issue in an qlikview app.

In one tab there are two charts.one is bar graph another is straight table.when I am opening that particular bar graph is coming fine but straight table is taking too long to load.So how to solve that problem?

[vishsaggi]

Can you upload a sample qvw file to look into ?

[Ronnie_Taborn]

What version are you on? 

[#4]

I am using Qlikview 11

[Anonymous]

Do you have any complex calculated dimensions in the table?

How many dimensions are you loading?

How many rows of data is loaded?

If you have more dimensions and rows, put a calculated condition that data should be displayed only at least 1 yr is selected, so that data will be loaded for that year and its fast.

Thanks,

Nithesh

[peter_turner]

Adding to Nithesh's reply your calculated condition could also stop the table displaying your entire dataset when a user clicks 'Clear All'.

This can usually be done easily in an expression like:

if(count(YourField)>1000,0,1)

Its best if YourField is a key field and a numeric value or a flag as its quicker to count them.

If there are more than 1000 rows then it will return 0 and stop the table calculating, else 1 and display the table.

Also to educate the users, do they really need a table with many thousands of rows, what are they going todo with them all?

You can also change the default table message of 'Calculation Condition unfulfilled' from the 'Error Messages' button in the table properties.