RSS-Feeds & Newsletter
Author Archives: Stefan Walther
QlikTip #15: Changing the layout-raster in QlikView’s design mode (translated)
While designing your QlikView application it is quite useful to enable the design-mode and at the same time the design-grid (Ctrl+G or Menu => View => Design Grid). This is very useful to align the objects within the user interface. Personally I prefer to work with a smaller raster: This setting can be found (saved [...]
QlikTip #3: Check whether a field exists or not (translated and improved)
If you want to load all fields in a table or a QVD file in loading scripts (so typically SELECT * FROM... scenarios), it is often necessary to know whether a field (within a table) exists or not. The following code example demonstrates how this can be achieved: Customers: LOAD * INLINE [ CustomerId, PostalCode, [...]
QlikTip #24: Using line-styles in Line-Charts to differentiate between actual and planning figures
Some months ago I was asked how one could change the line style within a “Line Chart” for distinguishing between actual and planning figures. The desired result: How can we manage that in QlikView? First I added a field named IsForecast in my demo-application to differentiate between actual and planning figures: LOAD * INLINE [ [...]
QlikTip #23: Deleting fields within a load-script dynamically
Some days ago I was asked how one could delete fields dynamically within/after a load-script in QlikView based on the name of the field/column. So all columns for example with a prefix “F_” should be deleted after loading all tables from a database. My first response was, that the “Table functions” (please have a look [...]
QlikTip #22: Restarting/Stopping/Starting services in QlikView 9
Even if already published on another Qlikview related blog I just wanted to have this here because I am using it quite often. For starting/stopping/restarting the QlikView Windows-services of QlikView server in version 9 I have prepared three batch-scripts which I call on demand: Restarting all QlikView related Windows-services @echo off REM ------------------------------------------------------- REM - [...]
Nice Read #1: Gartner’s Magic Quadrants 2009/2010 and Qlikview
Gilles from www.quickqlearqool.nl has written a nice review of the new Gartner’s Magic Quadrant 2010: The most interesting fact in Gartner’s analysis is that QlikTech/QlikView is not a visionary anymore! Some quotes from Gilles article: THERE ARE NO VISIONAIRIES ANYMORE!! Even Qlikview isn’t a visionary anymore. … the explanation for Qlikview not being part of [...]
Stefan WALTHER
QlikTip #25: How do you organize your QlikView projects in your file system?
Posted in Development /QV Developer, Load Scripts, QlikTips, Strategy