how to increase the performance of qvw while opening

[#1]

Hi,

I have one qlikview file with size 220,842KB and it will be increasing based on the data daily. Because fo this if I clikck on any straight table or any pivot table it is taking so long to open . In the task manager the CPU usage is 100% when I am openeing this file.

Could anyone help me what is the solution for this. Do I need to increase any RAM size . My manager is asking me about this and I don't have much awareness in this. Please could anyone help me how to increase the performance i,e how to solve this.

Thanks.

[amars]

Hi Amelia,

You can try many things to optimize your application.

1. Do optimize your data model. Use some Start Schema or Snow Flake Schema to avoid repeating the same values multiple times.

2. Use Set Analysis in you expressions and try to keep your expressions as simple as possible.

3. Avoid using calculated Dimensions, rather create them in scripts and use it.
4. Use incremental load

You can further search for Optimization in Qlikviewcommunity.

Thanks...

[#3]

Thanks for this and actually I need to use all straight tables and need to use the columns as it is from sql table to straight table. That's the reason it is increasing the size. could you tell me how I can I use Set analysis as I wouldn't need for this application and more over to get the columns I used the expression for most of the columns.

=Only(Columnname)

could you please suggest me.

Thanks.

[jagan]

Hi,

If you want to load the dashboard faster while opening then use the Calculation Condition option in General tab of each object which will take more time to load.  Restrict to load the chart until any selections are made after opening like this

=Count(IDField) > 50000

The above expression restricts to load the chart until the selected filter values satisfies the condition.  If 50000 is loading faster then increase the value.

Regards,

Jagan.

[amars]

Hi Amelia,

The Only function will return value for the Columnname if only one possible value is available for the field.

In case you do not have any calculations or formula you can rather try using Table Box. But for a Table Box you will have horizontal Scrollbar's in case the number of fields to display are more whereas for the Straight Table the chart size is variable based on the no of dimensions to be displayed.

Also if more data needs to be shown then using a Table box over a Straight Table is always better.

If you want to learn how to use set analysis please refer the attachment.

Thanks...

[tresesco]

If you don't have any expression to show in the table, you should try using Table box instead of straight table, that might give you a bit of ease on stress.

[dmohanty]

Hi,

As your talking about tabular reports used as Straight tables etc, I assume those are transactional reports used for comparisions. If your data in QVW is increasing day by day, first check the requirement if you can restrict the data to show some specific years (time period) of data. In this way you can eliminate the incoming of past data that have become obsolete

For example, If your App is having data of 8 years (let say starting from 2005), check if those are really needed. Because after 2 years the app will be having 10 yeards of data. In this case, you can eliminate the past data by filtering data for 18 months or 24 months or 30 months etc.

Better extract the limited records in QVDs itself and use in the data model. The only way to restrict the size of app being gradually increased!!!

Regards!!!

[#8]

Thanks and I have a combination of columns and need to write some expressions i,e

sum(amount) .

so, in this case could you tell me how to use both to fit please,

Thanks.

[ngulliver]

Hi, Amelia.

On the Performance tab in your task manager, how many CPU Usage History tables can you see ? If it is just one it means you are only using one core processor and you may want to request additional core processors so that you don't max out on CPU.

In addition to the suggestions already mentioned, have a look at http://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/ as this may help.

Also, think about doing the heavy lifting in a QVD generator so that your front end is only reading in qvd files and not calling SQL databases etc.

Regards,

Neil

[#10]

Thanks and still it's getting long to open please could you help me as I am really stuggling this but I need all the columns data with blank values as well.