Ohh My God! A year ago I submitted this feature request for 10:

>>When doing a more "professional" developing it would be nice to do version control and be able to track development done by the different project members... I don't want to check in the binary QVW file. I would rather check in the script and control definition files... If Qlikview consist of two parts. The data repository and a XML script and object definition file containing the definition for all objects. It would be easier to have a multi developer development in a controlled fashion.<<

Ever since leaving PHP coding for QlikView - I've always missed the Handy isset function to check if a variable, well, isset. But its actually possible to use the isnull function to do the same in the script. Just remember not to use $ sign expansion! Since this will evaluate the variable, before its passed into the function.

This works nicely:

If isnull(foo) Then
    Let foo = 'bar';
    trace now it exists;
Else
    trace exists;    
End if

In time in PHP programming we often did a "Helper" function. A helper does something genericly easier than the code provided by the application. For most parts we had a helper application that we used for logging certain errors into a database.

With QlikView I've started to setup a LogHelper to help log what goes on in my Collect scripts. This is hugely helpfull since it provides a log of how the load script have performed historicly, and I can easely see if there was a hickup at one of my clients.

When loading data from many tables, and when its necessary to do more than the usual store and drop commands. You often end up with a lot of code that does stuff: Like fetching last timestamp for the load or storing the incremental data. And quite a lot traces to make its works correctly.

So I tend to write some functions for this which lets you save many line of code and make maintenance so much easier.

These functions should work generically for any tables that both have a modified date and an auto incrementing id fields.

Hi,

I've read XKCD for some time now and stumbled across a version that I had to hack into a QlikView compatible version:

One of the really big things for Enterprise developers like me is being able to create master objects, so you easely can propergate changes across a QlikView file. So in QlikView 10 they introduce Linked Objects.

You can create a linked object by dragging and holding shift + ctrl down, or you can copy it and paste it as Linked Object.

This essentially means that you can create a single menu and copy that to your other sheets, and then when some must be added or changed, the change will propergate to any object that is linked to those menu objects!

We have just started beta testing of QlikView 10, and some nice feature small improvements have been made together with all the big ones:

You can now move an item that has no caption by holding Alt and dragging.

This even works when a object has Allow move/resize unchecked.

You can use click and then press ctrl +shift to create a linked object. A linked object will let you have unlimited copies of a object, but if you change any properties one either the master or any of with linked items, then they will propergate to all the linked items!

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 f.ex. the current selection box this isn't the all to good. At first I used the server setting "disallow moving and sizing object" but when i developed a new application i needed to uncheck this setting. After this i needed to change (manually) all of the object settings.

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 code snippet below is taken from one of my Collect.qvw files.

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.  Citrix is aware of the issue, but they do not have an ETA on when they might issue a new client to fix the problem.  Until then, follow these instructions to restore all functionality:

1.  Close all open web browser windows

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 for the driver.

In the connection tab, set the Data source to: LDAP://your.adserver.com < where the last part is any AD node in the network.

And use any username that has the rights to read the AD

In the edit script place the lines below:

 With the release of QlikView 8 it became possible to setup of split QlikView servers, one that handles reloading of documents and one the serves documents. With QlikView 8.x this was a daunting task, where many .xml config files needed to be edited. Now with QlikView 9 it became manageable setting it up. Only a little tweaking is needed and no more xml config file editing.

Hi,

If you want to restart your qlikview services running QV 9 periodically put this into a bat script:

REM Shut it down:
NET STOP "QlikView Directory Service Connector" 
NET STOP "QlikView Distribution Service"
NET STOP "Qlikview Management Service" 
NET STOP "QlikView Publisher Command Center Service" 
NET STOP "QlikView Server" 
NET STOP "QlikView WebServer"
REM Turn them back on:

This is a guide suitable when you are about to install a QlikView Server 9 SR 2 on a Windows Server 2008 machine. 

Recommended prerequisites:

• Domain Service account, with never expiring password, which may look up users in the AD.

• A local administrator account for the server, which will perform the install (you can use the service account).

• Server with preferably static IP and a hostname.

The Built-in webserver in QlikView 9 can be used for redirections of url's. This example will show how you access the accesspoint by just typing in the hostname for the server and nothing else. The QlikView Webserver will now show the "Accesspoint"-content also on the "root" (hostname/)

I know that this has been a lot talked about. A good text editer with syntax highlighting for QlikView, why on earth does this not exist!? Follow these simple instructions and you will get it. I've been working a few months on getting this right. QlikTech sadly has no xml file with the whole syntax and functions in it. So that I had to copy paste and edit the whole thing from the manual, also I'm slowly working on a fully supported autocompletion function but this might take a while.

I've wanted to write about this for a long time. You can really do some cool stuff with the ajax tools and regular html pages.

So what I want to do is to add some QlikView objects to a regular html page, and have them behave just is in QlikView. When I select something i one box then it propergates the selection to the others.

I was discussing with QlikTech which was the fastest method of adding a small relational table to a table. Basicly you have 3 options: Table join, Mapping load and If(). The table join method is discarded on forehand because it will run though every row in the loaded table. The mapping load method has two methods either you can in your load syntax use ApplyMap(Field,Map1) or afterwards do a Map Field Using Map1. The last method is doing a simply If inside your load. According to QlikTech the two Mapping methods should be the fastest.

I’m working on the QlikView combo certification and have noticed this minor bug in the LOAD * RESIDENT syntax.

AcctInvoiceReceiptstxBillingTreat:  
LOAD KEY_MEDNO,Treat.TX,KEY_INVOICE,
KEY_ACCTNUM,Treat.MNAME RESIDENT tab1 ;

If I do the above, a table with the label AcctInvoiceReceiptstxBillingTreat is created.

If I however do a * load then

AcctInvoiceReceiptstxBillingTreat:  
LOAD 
* RESIDENT tab1 ;

The table created is labelled tab1.

In QlikView 9.0 beta QlikTech has removed the most important button and replaced it with a Home button. The button, in default resets the application, or if you want sets a custom selection. Sadly this selection is not dynamic, so of very little use. I've told QlikView that this is a really bad function, and that they should keep the clear button. So every who agrees tell them also, so we can get this fixed!