Sign in to follow this  
Followers 0
ptrex

QlikView - Data Visualisation Tool

8 posts in this topic

#1 ·  Posted (edited)

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
1 person likes this

Share this post


Link to post
Share on other sites



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

Share this post


Link to post
Share on other sites

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


When the words fail... music speaks

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

#5 ·  Posted (edited)

What does this and for what is useful ?

Edited by Rickname

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
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
Sign in to follow this  
Followers 0