QlikView - Data Visualisation Tool

[ptrex]

QlikView - Data Visualisation Tool

This powerfull Data Visualisation Tool, has an extensive COM object Model to control the application

QlikView Examples

The good news is they have a free fully functional working version for personal use. Free Download

This will get you started.

expandcollapse popup

$oMyError = ObjEvent("AutoIt.Error","MyErrFunc")
 
$Qview = ObjCreate("QlikTech.QlikView")
 
if IsObj($Qview) Then
 MsgBox(0,"",$Qview.OSName & " " &$Qview.OSVersion)
Else
 MsgBox(0,"","NOK")
 
EndIf
 

$Qview.MsgBox("QlikView Version " & $Qview.QvVersion )
 
$Qview.OpenDoc("C:\QlikView\SALES per Region.qvw")
WinSetState("QlikView", "", @SW_MAXIMIZE)
 
$ActiveDoc = $Qview.ActiveDocument
 
; INSERT HERE and start every call with "QvDoc."
 
$Sheet = $ActiveDoc.ActivateSheet("Sales By Region - YTD")
 
$Sheet.FitZoomToWindow
 
ConsoleWrite($ActiveDoc.GetVariable("vCurrentYear") & @CRLF)
ConsoleWrite($ActiveDoc.GetPathName & @CRLF)
 
;$Qview.Quit
 

Func MyErrFunc()
  $HexNumber=hex($oMyError.number,8)
  Msgbox(0,"COM Test","We intercepted a COM Error !"       & @CRLF  & @CRLF & _
    "err.description is: "    & @TAB & $oMyError.description    & @CRLF & _
    "err.windescription:"     & @TAB & $oMyError.windescription & @CRLF & _
    "err.number is: "         & @TAB & $HexNumber              & @CRLF & _
    "err.lastdllerror is: "   & @TAB & $oMyError.lastdllerror   & @CRLF & _
    "err.scriptline is: "     & @TAB & $oMyError.scriptline     & @CRLF & _
    "err.source is: "         & @TAB & $oMyError.source         & @CRLF & _
    "err.helpfile is: "       & @TAB & $oMyError.helpfile       & @CRLF & _
    "err.helpcontext is: "    & @TAB & $oMyError.helpcontext _
   )
  SetError(1)  ; to check for after this function returns
Endfunc

Edited January 30, 2014 by ptrex

[Tjalve]

This is AWSOME! Ive started messing abit with your example code but i cant get the "change sheet" to work. And also i cant read a varibale. I the first error i get: 80020009 (Unspecified Error)

The secound is: Variable must be of type "Object". Error: 000000A9

[Andreik]

Looks great but where is SALES per Region.qvw? An example file is welcome.

[Tjalve]

I actually got this to work pretty good (just testing). And im now able to do several selections and loop on a field and print a specific report. I thank you for getting me started on this.

[Rickname]

What does this and for what is useful ?

Edited January 29, 2014 by Rickname

[ptrex]

@Andreik

I can't share the SALES per Region.qvw file because it holds company information, sorry

And secondly using the Free version you can't share the qvw files. There is alwas a catch using a free version.

@Tjalve

Nice to see you like it.

@Rickname

I updated the links in the first post. It holds a product demo.

Enjoy!

ptrex

[Andreik]

That's ok, I asked just to see an example because it looks very complicated for me now. From what I saw on google, QlickView it's pretty good as data visualisation so I have to read the help file because I like it. 

[ptrex]

@Andreik,

Good to see you like it.

Rgds

ptrex