Jump to content

QlikView - Data Visualisation Tool


ptrex
 Share

Recommended Posts

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.

$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 by ptrex
Link to comment
Share on other sites

  • 5 months later...

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

Link to comment
Share on other sites

@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

Link to comment
Share on other sites

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.  :party:

When the words fail... music speaks.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...