Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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
Specialist
Specialist

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