topic Re: Data checker in QlikView

Data checker

pk — Mon, 06 Dec 2021 15:31:09 GMT

Hello Team,
Want to create one application in Qlikview as Data Checker, this app should check below points-

-Check QVD1 size, if it is 0KB then set Flag1=False

-Check count of QVD1 >0 then set Flag2='Data is available'

Thanks in advance

Re: Data checker

sergio0592 — Mon, 06 Dec 2021 17:37:46 GMT

Hi,

You can use FileSize function for point 1. And NoOfRows function for point 2.

Re: Data checker

pk — Wed, 08 Dec 2021 13:37:57 GMT

I tried to use Filesize function but am not getting expected output

if there are no records in the qvd (only Labels/headings are available) then too filesize fun is showing result >0 like 1700KB something depends on the no of headings/labels
So can not able to check that qvd has data or not using filesize fun.

is there any other way to check QVD is empty or not ? or QVD size=0 and set the flag.

Can anyone help

Re: Data checker

anat — Wed, 08 Dec 2021 14:27:24 GMT

if QvdNoOfRecords('Qvd name') =0 then u can consider qvd size also 0