Category Archives: Development /QV Developer

QlikTip #36: Loading a mapping table directly from a QVD file (QV10 SR2+)

By Stefan Walther 2 Comments
Also posted in Load Scripts, QlikTips, QlikView 10
In the past it was not possible to load a mapping table directly from a QVD file. We had to use some workarounds to break the optimized load like: Mapping_Map: Mapping LOAD Field1, Field2 FROM qvdFile.qvd (qvd) WHERE 1=1; or Mappping_Map: Mapping LOAD Field1, Field2, 1 as Field_temp FROM qvdFile.qvd (qvd); DROP FIELD Field_temp FROM [...]


read more


QlikTips #33: Google Maps are not working anymore in QlikView 10 SR2 ???

By Stefan Walther 8 Comments
Also posted in Charts, Design & Layout, Integration, QlikTips
This week I have received some eMails and read some posts that Google maps do not work anymore after upgrading to QV 10 SR2. This QlikTips shows how to overcome these troubles ...


read more


Nice Read/Watch: QlikView Scalability Videos

By Stefan Walther Leave a comment
Also posted in Nice Read, Strategy, SysAdmin/Installation
Recently there have been posted some really nice and interesting vidos on Scalability with QlikView on YouTube: QlikView Scalability – Video 1: Overview “This video introduces the 5 part video series and provides a high-level overview of the topics associated with understanding how QlikView can scale.” QlikView Scalability – Video 2: System Resource Usage “This [...]


read more


QlikChallenge #1: Getting the max value over multiple expressions

By Stefan Walther 11 Comments
Also posted in Load Scripts, QlikChallenge
This is the first challenge for all QlikView professionals ... Have a look at it and post your (most elegant) solution!


read more


QlikTip #32: Exporting multiple QV objects to a single Excel document

By Stefan Walther 82 Comments
Also posted in Macros, QlikTips
This article demonstrates how you can easily export multiple QlikView objects to a single Excel document without writing a lot of macro code.


read more


Visual Studio 2010 SP1 is available (fixes the OCX bug)

By Stefan Walther Leave a comment
Also posted in APIs, Technology News
Some days ago the Service Pack 1 for Visual Studio 2010 has been published. This also fixes the Visual Studio bug when trying to add the QlikView OCX control which is also described in the Reference Manual of QlikView: I have just tested this and registration of OCX now works again as expected.


read more


QlikTip #31: Access Qvd Meta Data programmatically without using QlikView but pure .net & C#

By Stefan Walther Leave a comment
Also posted in APIs, QlikTips
This article shows you how you can access the xml header of a Qvd file without using QlikView programmatically using just .net & C#.


read more