Posted by William on 28/01/2009 under How To | 
Sometimes you want to compare charts with a preconfigured set of data. For example:
I have 3 stores which are selling the same products. On the same tab I have 3 pies, for store1, store2 and store3.
When I use detach I can select the right data for store1, store2 and store3 but I’m not able to select different productgroups and drill down in the pie. Also when reopening qlikview or reloading the data, the detach function is gone.
Read more of this article »
Posted by Gilles on 19/01/2009 under How To |
In many situations you have different sets of databases to connect to. In the real world you’ll probably have a development database, Quality Assurance databases and a production environment database. I can imagine when your Qlikview application is under construction or while testing you would like to switch databases very easily.
It’s relatively easy to create a simple switch with which you can switch between development and production connections. Let’s show an example:
SET vProduction= 0;
IF vProduction = 1 THEN
···ODBC CONNECT TO MyOracleDBProd (XUserID is *****, Xpassword is ****)
SET vDBName = ‘MyOracleDBProd‘;
ELSE Read more of this article »
Posted by Gilles on 15/01/2009 under How To |
Putting comments in your scripts is good practice. It makes your scripts better readable and understandable for other users. In this post I’ll give you some tips about putting comments in your scripts.
As stated in my previous post about Tabs, I think it’s good to have some header comment. Put it on your first tab and make it something like below.
- Historical Information (1st tab)
- Created by (Original Author) and Date
- Modified by, Data and a short summary of what has been modified
- Databases Used
- Purpose of the application
If you’ve got ODBC connections with scrambled userID and password make a comment that states the userID. This will help modifiers of your script immensly because they will know which account was used Read more of this article »
Posted by William on 14/01/2009 under How To |
Sometimes when working with dates, it is better to keep the date fields outside the fact tables and create them in a table of their own. For instance, you may want to be able to see all dates, not only dates when something has happened. Below are two samples to create a master calendar. The first one contains a hard coded start year. The second one gets the start and end date from the fact table. This means you will always have all dates between the first and last date.
Read more of this article »
Posted by Gilles on 08/01/2009 under How To |
This post with tips is about scripting. How to set up your scripts initially and keep them maintanable and sustainable, so that other developers can find their way in your script and to set some sort of standard. One important thing to mention is that you’ll have to define your own set of standards. This is not the standard, but a start for a standard.
Utilizing Tabs in Script Editor:
It’s good practice to split up your load script into several tabs. These split ups must be logical ofcourse. Below you’ll find a suggestion for the first three tabs.?
Read more of this article »
Posted by Gilles on 07/01/2009 under How To |
For a while now I have been looking for some best practices. How to set up a project and create a sustainable and maintanable solution, how to organise your scripts, how to create a good model, how a design should or could be. The Information that i will use comes from a presentation from Shima Nakazama a senior consultant at Qliktech Netherlands, ofcourse my own experiences and other stuff I’m able to find on the internet.
I’d like it to make it a serie of best practices posts. And I’ll start with scripting best practices. To keep things structured I will update this post with links to all best practices posts, see below
Read more of this article »
Posted by Gilles on 06/01/2009 under Articles, How To |
Yesterday I was working on a chart. This chart had numbers on the y-axis in millions. I used to divide my measure/expression by 1000 to get smaller numbers that would mean the same. Now I found out a way to do that much easier. Go to the Chart Properties and then the Number tab. 
There you’ll find a box wich is called Thousand Symbol. You could enter any value or symbol like dollar sign or euro symbol and all your values are divided by 1000. So I entered $K to state that numbers on the y-axis are in thousand dollars.
Posted by William on 05/01/2009 under How To |
When using Qlikview Analyzer Java Client with Qlikview files which are built and used on a high resolution (for example 1920 by 1200). The application in the browser is shown in a smaller resolution so it doesn’t fill the whole screen which results in an ugly scrollbar. When using the Internet Explorer plugin everything looks fine but I prefer to have the freedom of choosing another browser. The following solution will fix the problem:
Read more of this article »
