Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In one of our projects we made integration between Microsoft Visio and QlikView.
The short description is that we made a network model in Visio with nodes and links between the nodes. By clicking on a node we could see (in QlikView) which deliveries we had on the selected node and by clicking on a link in Visio we could see which deliveries flowing via this link.
It is a very simple integration where I have Visio on one screen and QlikView on the other screen.
But if this is of interest for other I can provide some more details.
Hi Ronny, I'm very interested to see how you implemented the details.
Ok, I will prepare a simple example for you next week.
- Ronny
Hi again
I took some time to prepare the example and I may have added more complexity than you asked for but any way.
In short what I do to integrate Visio with Qlikview is as following:
The integration is to use variables in expressions in QVand then make Visio updating these variables.
This is not Visio specific. You could e.g. do the same in Excel. When a sheet is updated press a button to initiate a qv reload of changes in the Excel sheet.
Private Sub cmd_QlikView_App_Start_Click()
' ** Open QV with named document ***
Dim vFilePath As String
vFilePath = ActiveDocument.Path
vFilePath = vFilePath & "Network_Test.qvw"
'Debug.Print vFilePath
Set Qv = CreateObject("QlikTech.QlikView")
Set QvDoc = Qv.OpenDoc(vFilePath, "", "")
'Debug.Print vFilePath
QvDoc.ActivateSheet "Transport"
Set vsoWindow = ActiveWindow
End Sub
Above is the macro to initiate the qv document and below is the macro to reload the initiated document.
Private Sub cmd_QlikView_App_Reload_Click()
'** Reload QV Document ***
QvDoc.Reload
End Sub
I have attached 4 documents.
The solution is not high quality or a professional integration, but more a rapid test of integration possibilities with QlikView. But the solution is generic so you can expend the network model and add nodes and links. The only thing you need to do is to create a new Network_List file (button available in Visio).
Also be aware of that I have defined a direction for all links. Transport in this direction is called flow. Transport in the opposite direction is called reverse.