Integration with Microsoft Visio

[ronnywaage]

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.

[#2]

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

[ronnywaage]

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

- Ronny

[ronnywaage]

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:

1. Create a macro in Visio to open an instance of my QlikView App
2. Create a macro in Visio to reload the qv document
3. 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.