topic Re: Qlikview File Size in QlikView

Qlikview File Size

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I use Qlikview V 11

I have a question about the files size ( Qvw) :

I created a reporting with several dashboards.

The size is 1,3 Go ( too big)

when I delete all the dasboard, the size is still 1,3 Go

when I reload Data the size is still 1,3 Go

I done a test :

I created a new reporting without any dashboard and when I load the same Datas, the file size is 400 Mo.

I don't understand

Is there any function in Qlikview as " Shrink" in a Database to reduce/optimize the file size ?

thanks for your help !

Re: Qlikview File Size

Anonymous — Fri, 22 Apr 2016 10:50:53 GMT

Hi Daniel,

yes there is Reduce data in qlikview in two ways:

1. remove all values

2. keep possible values

Under File -> reduce data can be found

regards,

kaveri

Re: Qlikview File Size

Anonymous — Fri, 22 Apr 2016 10:58:53 GMT

On the qvw's Document Properties, General tab one can set Compression.

Whilst reducing the qvw size this will have a performance hit due to the time taken for the compression / decompression.

Re: Qlikview File Size

syukyo_zhu — Fri, 22 Apr 2016 10:58:54 GMT

Hin

You can compress your document qlik.

You can go to document propertise\general\save format \compression\High

Hopr helpful

Re: Qlikview File Size

Colin-Albert — Fri, 22 Apr 2016 11:02:18 GMT

Perhaps you need to optimise the data you have loaded into your app.

The app size can depend on the variability of your data as much as the number of rows.

Replacing timestamp fields with date fields can if the time is not required can change the storage requirements.

This post has more details The Importance Of Being Distinct

Re: Qlikview File Size

Fri, 22 Apr 2016 11:27:20 GMT

Thanks for your answer, colin

But i 'll like to understand how Qlikview run!

1 - I created a reporting with several dashboards. >>Report 1: size is 1,3 Go

2 - A new reporting without Dashboard but with the same Data set >> Report 2: size is 400 Mo

3 - when I deleted all the dashboard from the report 1 : Size is still 1,3 Go

I try to understand what is the difference between the 2 reports : The gap is 900 Mo

Re: Qlikview File Size

Colin-Albert — Fri, 22 Apr 2016 12:55:41 GMT

If your app size increases significantly when you add your dashboards it sounds like you have some inefficient expressions that are creating large temporary datasets.

Can you post a (reduced) example of you app? Then we can advise on your actual app rather than generic examples.