QVD Comparison

Anonymous — Wed, 05 Oct 2016 21:24:03 GMT

Hi ,I want to show the count of rows in the qvd file generated yesterday and count of rows in qvd file generated today.So that it can be used as a data quality application.Can some one help me with the logic

Expected out put :

Name of QVD	Record Count Yesterday	Record Count Today
Sales.qvd	5000	5050
invoice.qvd	3000	3500

Re: QVD Comparison

marcus_sommer — Thu, 06 Oct 2016 06:41:41 GMT

You could scan your qvd-folder each day with a filelist-loop and load the meta-data like vFile, filetime(), qvdnoofrecords() and add those informations into a another qvd in an incremental approach. If you only want to compare today with yesterday it might be enough to store the number of records into a variable or you used both approaches.

Re: In context of For Each ... FileList(), how to make NoConcatenate

- Marcus

Re: QVD Comparison

Anonymous — Thu, 06 Oct 2016 20:19:36 GMT

IF (isNull(qvdCreateTime('..\QVD\QVD_Monitor.qvd'))) THEN

For each vFile in FileList('M:\Qlikview_IMO_Analytics\Dev - KK\QVD\*.qvd*')

     let vFileSize    = Alt(FileSize('$(vFile)'), 0);

     let vRecordCount = Alt(QvdNoOfRecords('$(vFile)'), 0);

     let vCreatedon   = Alt(FileTime('$(vFile)'), 0);

     let vDaysBehind = num(Today()) - num(floor(vCreatedon));



     QVD_Monitor:



       LOAD

          '$(vFile)'      as FileName,

          $(vCreatedon)   as GeneratedOn,

          $(vRecordCount) as RecordCount,

          $(vFileSize)    as FileSize,

          $(vDaysBehind) as NumDaysBehind,

           NOW()          AS ReloadedOn

          //RangeSum(Peek('FileCount'), 1) as Filenum

     AUTOGENERATE(1)

     ;

Next

STORE QVD_Monitor into [..\QVD\QVD_Monitor.qvd];

ELSE

QVD_Monitor:

LOAD FileName,

     GeneratedOn,

     RecordCount,

     FileSize,

     NumDaysBehind,

     ReloadedOn

FROM

[..\QVD\QVD_Monitor.qvd]

(qvd);

For each vFile in FileList('M:\Qlikview_IMO_Analytics\Dev - KK\QVD\*.qvd*')

     let vFileSize    = Alt(FileSize('$(vFile)'), 0);

     let vRecordCount = Alt(QvdNoOfRecords('$(vFile)'), 0);

     let vCreatedon   = Alt(FileTime('$(vFile)'), 0);

     let vDaysBehind = num(Today()) - num(floor(vCreatedon));

Concatenate

     QVD_Monitor:



       LOAD

          '$(vFile)'      as FileName,

          $(vCreatedon)   as GeneratedOn,

          $(vRecordCount) as RecordCount,

          $(vFileSize)    as FileSize,

          $(vDaysBehind) as NumDaysBehind,

           NOW()          AS ReloadedOn

          //RangeSum(Peek('FileCount'), 1) as Filenum

     AUTOGENERATE(1)

     ;

Next

STORE QVD_Monitor into [..QVD\QVD_Monitor.qvd];

end if

I used hat script and used pivot table to show the comparison..Thanks for your help

topic Re: QVD Comparison in QlikView

QVD Comparison

Re: QVD Comparison

Re: QVD Comparison