topic Re: Qlikview performance issue in QlikView

Qlikview performance issue

Mon, 26 Jan 2026 18:19:17 GMT

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?

Re: Qlikview performance issue

vishsaggi — Fri, 15 Jul 2016 18:40:34 GMT

Can you upload a sample qvw file to look into ?

Re: Qlikview performance issue

Ronnie_Taborn — Fri, 15 Jul 2016 18:59:40 GMT

What version are you on?

Re: Qlikview performance issue

Fri, 15 Jul 2016 19:32:46 GMT

I am using Qlikview 11

Re: Qlikview performance issue

Anonymous — Sat, 23 Jul 2016 09:02:42 GMT

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

Re: Qlikview performance issue

peter_turner — Thu, 25 Aug 2016 15:41:56 GMT

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.