Integration with Microsoft Visio

ronnywaage — Sun, 25 May 2014 09:30:46 GMT

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.

Re: Integration with Microsoft Visio

Sun, 25 May 2014 10:22:51 GMT

Hi Ronny, I'm very interested to see how you implemented the details.

Re: Integration with Microsoft Visio

ronnywaage — Sun, 25 May 2014 21:34:58 GMT

Ok, I will prepare a simple example for you next week.

- Ronny

Re: Integration with Microsoft Visio

ronnywaage — Sat, 31 May 2014 23:05:31 GMT

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:

Create a macro in Visio to open an instance of my QlikView App
Create a macro in Visio to reload the qv document
Detect changes in selection in Visio and if change
1. Find selected object
2. Decode object (find name)
3. Update variable in qv document

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.

Bookings: Test case with transport orders and sales (Excel)
Network: Admin page for remote access to QlikView and network model
Network_Test: QlikView test app
Network_List: The network model exported from Visio to a csv file.

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.

topic Re: Integration with Microsoft Visio in QlikView

Integration with Microsoft Visio

Re: Integration with Microsoft Visio

Re: Integration with Microsoft Visio

Re: Integration with Microsoft Visio