Implementing proper Regression Testing using NPrinting

[#1]

Hi,

I would like to share my "a-ha" moment: NPrinting allows to implement regression testing for QlikView that was so much requested from me in the last years.

The ingredients:

-get some data (database, text files, Excels..)

-make a QlikView script loading data above

-make some charts and formulas

-using NPrinting make HTML reports. Nothing fancy, just a table with few columns of numbers

-add NPrinting filters to define a day, say yesterday (or January first ). The assumption is that past numbers do not change anymore.

-manually check the numbers

-rename the HTML file (ex "sales_report_finland_2015_01_01.html") to  "reference_sales_report_finland_2015_01_01.html"

-make a batch file like the one bellow and run it !

rem refresh QlikView file

"C:\Program Files\QlikView\qv.exe" /r whatever.qvw

rem generate NPrinting reports

"C:\Program Files (x86)\NPrinting\Client\NPrinting.exe" /NprintingFile whatever.nsq /Job "regression test"

fc "sales_report_finland_2015_01_01.html" "reference_sales_report_finland_2015_01_01.html" > nul

if %ERRORLEVEL% NEQ 0 (

  echo Sales Report regression test failed

)

The regression test will fail if:

• the database / files alters history
• the loading script has "new features" that are "new bugs"
• same for the chart formulas

Do you currently have other ways to implement regression testing ?

Cheers, Alex