Archive

Posts Tagged ‘Qlikview’

Vizubi Excel

March 29th, 2012 admin No comments

Just came across a promising add-in for Excel.
Its called Vizubi Excel and is part of a larger Development / Data platform
You can use it to load data from QVD’s ( Qlikview data [blob] files )
The beauty is the Add-In for Excel is free … but only available in a 32 bit version

So no I need to set-up a 32 bit installation and go back in time to test this…

Does anybody have any experience with Vizubi please let me know…

regards

Jelle-Jeroen

Categories: Excel, Qlikview Tags: ,

64 bit Windows with 32 bit Qlikview conflict

June 28th, 2011 admin No comments

L.S.

If one has installed a 64 bit Windows OS and he tries to use the 32 bit Qlikview 9 application
He can encounter the following error message:

SQL Error:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

This means you can’t use the 64 bit driver with the 32 bit application.

The Solution:

One should run odbcad32.exe from the SysWOW64 system folder and create an ODBC (32 bit) link.
This ODBC link can have the same name as a 64 bit one and can only be accessed / edited / viewed via this executable.

Regards

Categories: ODBC, Qlikview Tags: ,

Using a computer with multiple versions of office installed in combination with Qlikview.

June 27th, 2011 admin No comments

We were experiencing problems with a qlikview report containing a script which mailed parts of a certain tab as embeded pictures.

The line of code qlikview errored on was: Set OutApp = CreateObject(“Outlook.Application”)

The error was: ActiveX component can’t create object: ‘Outlook.Application’

The user with this problem also had problems with sending a excel workbook as an attachment from excel and got the error message:

This led me to believe that the additional installation of some Microsoft Office 2003 products were the reason for this strange behavior. In Qlikview you don’t reference a version of the ActiveX component like in vba so I assume the latest installation is leading.

To prevent these kinds of errors one should do a repair of the office installation considered to be leading.

Categories: Excel, Qlikview Tags: ,