topic Re: How to check whether data is fetched or not.. in QlikView

How to check whether data is fetched or not..

engr_farhanqadr — Thu, 20 Aug 2015 21:16:21 GMT

Hi Folks,

Can any one guide me how can I create a qvw file which shows that others qvws runs are executed successfully and whether data is fetched correctly or not.?

Thanks,

Farhan

Re: How to check whether data is fetched or not..

swuehl — Thu, 20 Aug 2015 21:22:37 GMT

How would you determine that data is fetched correctly or not? I mean, if there is no script error?

Do you have any test on data volumen etc. in mind?

To track the completed reloads, I remember an application by Rob Wunderlich some time ago, that checked the reload timestamps of the QVWs (scanning the files in the application folder). Just can't find his app right now, but the idea sounds quite straight forward.

Re: How to check whether data is fetched or not..

engr_farhanqadr — Thu, 20 Aug 2015 22:03:13 GMT

Lets take an eg if I am generating qvd and its having the size as previous then there is no data fetch even if the script is run correctly.

Re: How to check whether data is fetched or not..

manojkulkarni — Fri, 21 Aug 2015 05:33:12 GMT

Let vOldCount= QvdNoOfRecords('OldData\Sample.qvd');
Let vNewCount= QvdNoOfRecords('NewData\Sample.qvd');

if( vOldCount =vNewCount) then

'No Update'

Else

'Updated'

End if;

Re: How to check whether data is fetched or not..

mohammadkhatimi — Fri, 21 Aug 2015 05:49:46 GMT

Hie..

LOAD

'Tablename' as QvdName,

QvdCreateTime('$(Path)Tablename.QVD') as QvdTime

AutoGenerate 1;

Hope this will helps u..!!

Regards,

Mohammad

Re: How to check whether data is fetched or not..

manojkulkarni — Fri, 21 Aug 2015 06:15:01 GMT

Get Meta data info of any QVD

Set QvdFileName = 'Sample.qvd';

LET vFileSize = FileSize(QvdFileName);

LET vQvdCreateTime = QvdCreateTime(QvdFileName);

LET vQvdNoOfRecords = QvdNoOfRecords(QvdFileName);

LET vQvdNoOfFields = QvdNoOfFields(QvdFileName);