Category Archives: QlikTips

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

By Stefan Walther 2 Comments
Also posted in Development /QV Developer, Load Scripts, 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


QlikTip #35: Some hints on working with the QlikView Designer (Part 2 – Moving/Copying Objects)

By Stefan Walther Leave a comment
Also posted in Creating Applications, Design & Layout
This is the second part of the series of articles summarizing some hints for working with the QlikView Designer. In this part I’ll show you what you need to know about “Moving/Copying objects” in QlikView. Part 1: Using the design mode of QlikView Part 2: Moving/Copying objects (this article) Part 3: Linking objects Part 4: [...]


read more


QlikTip #34: Some hints on working with the QlikView Designer (Part 1 – QlikView Designer)

By Stefan Walther 6 Comments
Also posted in Creating Applications, Design & Layout
A colleague asked me today to promote the two blog-posts where the QV10 feature of moving objects while pressing the ALT-key is explained (see qlikboard.com and guerillabi.com). I thought instead of just posting these two links I could deliver more value by starting a series of articles which cover most of the tipps & hints [...]


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, Development /QV Developer, Integration
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


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

By Stefan Walther 82 Comments
Also posted in Macros
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


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

By Stefan Walther Leave a comment
Also posted in APIs
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


QlikTip #30: How to delete existing QVD files via load-script

By Stefan Walther 4 Comments
Also posted in Development /QV Developer, Load Scripts, Macros, Settings, Strategy
In some delta-load scenarios it may be necessary to delete specific QVD files from within your load-script (QVD-Generator). This article shows three completely different ways to achieve that goal.


read more