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

[#1]

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:

A:

Fact:

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

B:

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.

[#2]

Hi Zhou,

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

[#3]

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

[NareshGuntur]

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

[vincent_ardiet]

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

[#6]

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

[#7]

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