Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
pk
Contributor III
Contributor III

Data checker

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 

Labels (2)
3 Replies
sergio0592
Specialist III
Specialist III

Hi,

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

pk
Contributor III
Contributor III
Author

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 

anat
Master
Master

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