topic File sizes are much different even though they contain the same data? in QlikView

File sizes are much different even though they contain the same data?

Wed, 15 Jan 2014 05:35:02 GMT

HI all,

I got two QV files (A.qvw and B.qvw). They are almost the same except the scripts of loading data. But the size of these two files are much different (A's : 19.4M, B's 26.9).

In A, i load Fact.qvd direcly. While i load the daily fact data using loop in file B. The script is like below:

Fact:

load * from .\qvd\Fact.qvd(qvd);

for i = 0 to step

let vDate = vStartDate + i;

load * from .\qvd\Facts\Fact_$(vDate).qvd(qvd) ;

next;

I have checked that Fact.qvd = Fact_1.qvd+....Fact_step.qvd.

I don't know how this happen.

Re: File sizes are much different even though they contain the same data?

Wed, 15 Jan 2014 07:00:45 GMT

Hi Zhou,

Do you have any reports/GUI Created in the B.qvw. If yes that is possible.

Re: File sizes are much different even though they contain the same data?

Wed, 15 Jan 2014 07:03:03 GMT

The size not only depends on data.. The Objects you created in the sheets also matters...

Re: File sizes are much different even though they contain the same data?

NareshGuntur — Wed, 15 Jan 2014 07:22:45 GMT

Hi Zhou,

This is unexpected. But I doubt as QlikView stores only the distinct values and the remaining values as pointers, may be in the direct load it is storing as expected where as in the for loop, it is treating and storing the individual tables differently which means that even two different load statements have the same value, it is storing the value two times as they are coming from 2 different tables.

Cheers,

Naresh

Re: File sizes are much different even though they contain the same data?

vincent_ardiet — Wed, 15 Jan 2014 07:43:49 GMT

Hi,

It's surprising. But, as you may have seen, the B method is far more quicker than the A one with huge quantity of data.

So, perhaps it's linked. The A method is slower but data are better organized.

Else, have you set a compression on your files (document properties/General/Save format)?

Regards,

Vincent

Re: File sizes are much different even though they contain the same data?

Wed, 15 Jan 2014 08:08:58 GMT

Actually, B is generated aftering i changed the load script of A (and run it). There is other difference between them but script.

Re: File sizes are much different even though they contain the same data?

Wed, 15 Jan 2014 08:19:13 GMT

No, there is no difference between them but the load manner.