The QlikView Blogroll

Change Move/Size setting macro

Guerrilla Business Intelligence - your savior in the BI jungle — Tue, 09 Mar 2010 10:44:50 GMT

In any qlikview application the object setting Move/Size is rather important, should the user be able to move the objects around? For most of the charts it might be good to be able to open more then one chart at the time. But for the menu objects and...(read more)

Developing in Multi Environment

Guerrilla Business Intelligence - your savior in the BI jungle — Tue, 02 Mar 2010 22:42:54 GMT

Do you work in multiple environments like sandbox, test and production? With the builtin function computername() and a few if statements the need to change your code and database connection each time when moving to another environment is eliminated. The...(read more)

Fixing latest Citrix on Mac

Guerrilla Business Intelligence - your savior in the BI jungle — Tue, 23 Feb 2010 10:39:15 GMT

This works for Firefox, Safari and other browsers. And fixes the mess Citrix made with its latest release. Mac OS X users running the latest version of the Citrix ICA client may encounter difficulties launching ICA files dished by a Web Interface site...(read more)

Seeing the Blindingly Obvious

Qlik Tips — Mon, 22 Feb 2010 21:53:00 GMT

Recently on QlikCommunity, I have proposed a solution however the very brilliant Oleg Troyansky proposed an even better solution: http://community.qlikview.com/forums/p/25381/96915.aspx#96915 Hi answer to the problem (excluding nulls, zero length strings...(read more)

Use QlikView to read an active directory

Guerrilla Business Intelligence - your savior in the BI jungle — Mon, 22 Feb 2010 16:27:45 GMT

Its really easy to use QlikView to read out a Active Directory. Here is how: Simple use a OLE DB connection and the "OLE DB provider for Microsoft Directory Services" which should be default installed in must windows computers if not google...(read more)

Reusing expressions -- chart column references

Qlikview Notes — Sat, 20 Feb 2010 19:42:00 GMT

It's often useful to avoid repeating lengthy expressions. Here's one technique for reusing expressions. Consider the chart below. The Expression for the column labeled "Net" is: =sum(Quantity * Price) * (1-Discount) Let's add another...(read more)

QlikApps Becomes QVApps

Qlikster — Thu, 18 Feb 2010 17:11:00 GMT

Just a short update to my previous post regarding the new 'App Store' style website which was recently launched for QlikView developers and users - This site has now been relaunched under the new name ' www.QVApps.com '. We are currently...(read more)

Build it with QlikView, Deliver it with SharePoint

Wipfli: Blog: QlikThoughts — Fri, 12 Feb 2010 00:00:00 GMT

SharePoint has become a viable delivery mechanism for your QlikView dashboard objects....(read more)

How to: Syntax highlighting in Qlikview

Quick - Qlear - Qool — Wed, 10 Feb 2010 10:53:21 GMT

Highlighting in UltraEdit: http://blog.birchroad.net/2010/01/26/ultraedit-wordfile-for-qlikview/ with thanks to the Birchroad Blog Highlighting in Notepad++: http://guerrillabi.com/syntax_highlighting_qlikview with thanks to Guerrilla Business Intelligence...(read more)

QlikTip #22: Restarting/Stopping/Starting services in QlikView 9

qlikblog.at — Wed, 10 Feb 2010 07:24:51 GMT

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...(read more)

Setting Initial Selections in Version 9

Qlikview Notes — Mon, 08 Feb 2010 18:05:00 GMT

A common Qlikview requirement is that when a user opens a document, some type of dynamic selection -- like current date -- should be made. In QV 8 this entailed assigning a macro to the Document OnOpen event and using macro statements similar to this...(read more)

Nice Read #1: Gartner’s Magic Quadrants 2009/2010 and Qlikview

qlikblog.at — Mon, 08 Feb 2010 12:44:14 GMT

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...(read more)

QlikTip #21: Running QlikView 8.5 and QlikView 9 side by side

qlikblog.at — Sun, 07 Feb 2010 20:55:54 GMT

Just a very short (very, very short) tip today. I was asked how one could run QlikView 8.5 and QlikView 9 one one system … That’s absolutely no problem. During the installation of QlikView 9 Desktop (when having QlikView 8.5 already installed) just choose...(read more)

QlikTip #20: Why we do not need a SELECT-CASE/Switch-Case in QlikView load-statements …

qlikblog.at — Thu, 04 Feb 2010 22:59:06 GMT

I have recently received the question why there is no SELECT-CASE or SWITCH statement available in QlikView within load-statements. Sure, if you are looking into the reference-manual or into the help file, you’ll find the SWITCH-CASE-statement, but this...(read more)

Gartner’s Magic Quadrants and Qlikview

Quick - Qlear - Qool — Tue, 02 Feb 2010 12:45:25 GMT

I just received a link from William (@williamvanlith) through twitter (@gillespol) about Gartner’s Magic Quadrant 2010. I’ve been following Gartner’s magic quadrants on BI and datawarehousing for quite some time now and something struck...(read more)