Can anyone recommend an automated Qlikview scraping solution?

[pekhaqun]

My job involves pulling data from Qlikview and compiling it in Excel, and it's a slow, frustrating process.
I'm considering writing a Python application to do the pasting/ exporting/ saving every night, then having my Excel applications reference the saved files. Considering my constraints, does this sound reasonable? Are there any more efficient methods to pulling data out of the dashboards?

[Chip_Matejowsky · Accepted solution]

Hi @pekhaqun,

What is the business reason for pulling data from QlikView apps? Generating reports? You could use NPrinting to easily automate this task.

Best Regards 

[Albert_Candelario · Accepted solution]

Hello @pekhaqun ,

Indeed, using NPrinting would be much more efficient for your requirement: Find some information here:

Connecting Qlik NPrinting with QlikView ‒ Qlik NPrinting

Connecting to QlikView documents ‒ Qlik NPrinting

Añlso, you can enjoy the On Demand feature:

Qlik NPrinting On Demand add on for QlikView - YouTube

Cheers,

Albert

[NadMar]

If the Excel report that you have to load the data from has always the same format you cha use the load like this:

LOAD *
FileName() as NOME
FROM
[Path\*.xlsm]
(ooxml, embedded labels, table is sheet_name);

if you want to print daily a report you can use a macro like this one:

sub macro_name()

'ActiveDocument.ClearAll true 'CLEAR AL FILTER
'ActiveDocument.GetField("FILD_NAME").Select "valure" 'SELECT A VALURE 
'ActiveDocument.Fields("Field Name").clear 'CLEAR ONE FILTER / DIMENSION

'Oggi = ActiveDocument.Variables("Variable").GetContent.String  'SELECT VARIABLE

Dim F1,i
F1= "excel sheet name"


FilePath = "C:\REPORT\" ' File path can be changed later.
FileName = "Filename.xlsx"' 
File = "Q:\REPORT\Filename Template.xlsx"

set XLApp = CreateObject("Excel.Application")
set XLDoc = XLApp.Workbooks.Open(File)
XLApp.Visible = true
XLDoc.Sheets(F1).Select

''''''''''''''''''''''''''''

ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.GetSheetObject("OBJECT_ID").CopyTableToClipboard true
ActiveDocument.GetApplication.WaitForIdle

XLDoc.Sheets(F1).Range("A" & 3).Select ' INSERT THE CELL WHERE TO PASTE THE REPORT
XLDoc.Sheets(F1).Paste()

XLApp.DisplayAlerts = False
XLDoc.SaveAs FilePath & FileName
XLApp.DisplayAlerts = True
XLDoc.Close True
XLApp.Quit

endsub

So you can create a .bat file like this:

TIMEOUT 30

"C:\Program Files\QlikView\qv.exe" /l "filepath\TI - Copy.qvw"

then you can use the windows task sheduler to start the .bat 

and the trigger for the macro to refresh the data and load the macro once the file is opened

mind to allow the access to the system on the left part of the macro editor