Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You can use FileSize function for point 1. And NoOfRows function for point 2.
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
if QvdNoOfRecords('Qvd name') =0 then u can consider qvd size also 0