RobWunderlich / Qlikview-Components

A library for common Qlikview Scripting tasks
197 stars 98 forks source link

a summary function for QVDLoaders/creators #39

Closed HectorMunoz closed 7 years ago

HectorMunoz commented 8 years ago

Hi, I did this SUB time ago. To me is very helpful to see what qvd's are created and what was their last update, even their size.

I've uploaded the script and the example.

Hope this helps.

Best Regards

Ps. I'm very new to this github system, so I hope did the process the right way.

RobWunderlich commented 8 years ago

So the intent is to call this routine after each STORE to create stats for the QVD just created?

HectorMunoz commented 8 years ago

In fact, the routine also creates the QVD (given or not the filename), drop it from memory and also creates stats about, records, size and reload time involve.

in example you can replace this statements:

store table1 into table1.qvd (qvd);
drop table table1;

by

CALL Qvc_LoadStats('table1');

and the qvw will maintain the stats of the last reload.

HectorMunoz commented 8 years ago

image

an example of the routine result (also in the "Examples" folder)

RobWunderlich commented 7 years ago

Apologies for the delayed decision. This update is good, but too broad for the mission of QVC.