topic Re: Check the size of QVD in QlikView

Check the size of QVD

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

How can know the below:

1) Size of the QVD

2) If the size of the QVD is greater than 2 GB then alert need to be send.

Thanks,

Rohit

Re: Check the size of QVD

marcus_malinow — Tue, 11 Apr 2017 15:46:35 GMT

Hi Rohit

in your load script you can check the file size using the FileSize function.

If your QVD size is greater than 2Gb I'm sure your failed STORE commands will alert you to the issue! Seriously, you should think about segmenting your files.

Marcus

Re: Check the size of QVD

krishnacbe — Tue, 11 Apr 2017 16:29:03 GMT

Hi,

For checking the Size you can use FileSize function as suggested by Marcus.

Assign the Size to a variable and create a Alert for On Post Reload Event.

Tools -> Alerts

Re: Check the size of QVD

Siva_Sankar — Wed, 12 Apr 2017 02:28:17 GMT

Attached a sample of the script and where and how to create alert without using macro. If you follow the steps and you should be able to send alert emails to yourself once reloading the document if the file size is greater than 2 GB.

Siva

Re: Check the size of QVD

jood_ahmad — Sun, 11 Jun 2017 09:04:15 GMT

Hi Marcus,

Did you use QMC for segmentation can you help on that please.