Posted by Juan on 22/12/2009 under Articles, How To | 
For a long time one of the hottest discussions in the BI arena has been the concept of Enterprise BI vs Departmental BI, Top-down approach vs Bottom-up, Pragmatism vs Idealism. In this corner we have Spreadmarts, spreading like a virus throughout the organization to provide a quick and dirty fix to the desperate need of end users for timely information out of IT databases…..and in the other corner we have multiyear, multimillion Enterprise Data Warehouse initiatives that focus first on creating infrastructure, BI governance committees, data integration, while end users keep waiting for the very much needed information.
Read more of this article »
Posted by Juan on 27/09/2009 under How To |
In this post I want to share with you a good practice in handling the various expressions that exist in a QlikView document. The most used expressions are the ones used in charts, where they hold measures such as Sum(Sales), Sum(Price*Quantity), etcetera. These are the ones more likely to be reused by other objects and in different sheets. There many other expressions including Chart Attributes, Color Expressions and Show Conditions, you can see them all by going to the menu Settings/Expression Overview. Read more of this article »
Posted by Gilles on 05/05/2009 under How To |
In general performance is improved by moving the “problem” from application objects to the script driven database. This is often a trade off situation. Response time is enhanced and ad hoc capability is diminished. The recommendations below should not be seen as universally beneficial. Use them when they improve the general state of the application or when they make that little bit of difference that makes or breaks.
Cases:
1. Count ( Distinct ‘FieldName’)
2. If ( Condition(Text),…..)
3. Sum ( If (Condition, ‘FieldName’…))
4. If ( Condition, Sum(‘FieldName’)..)
5. If ( Condition1, Sum(‘FieldName’),
If (Condition2, Sum(‘FieldName’)……..
6. Sort text
7. Dynamic captions and text objects
8. Macro triggers ( “on change” )
Read more of this article »
Posted by Gilles on 13/03/2009 under How To |
excerpt from QlikNews Issue 8:
Tip 1: Search Settings
On the User Preferences > Properties General page, there is an area with“Search Settings.” Here you can switch between including excluded values in your search or not. In the first case, you can search over all values regardless of state. The alternative setting is when you want to “drill down” and search only the results of a previous search
Tip 2: Working with large documents
When handling large documents, the time spent opening and saving documents can become a little annoying. Instead, you can keep a limited-data (reduced) document and the script as separate files. This saves time when troubleshooting a document and when making changes in script and layout.
Tip 3: Variable for repeated expressions
Some expressions have a tendency to repeat over many objects. These expressions can be replaced with a variable so that one variable represents all the occurrences of the expression. (e.g. var1=sum(xyz); replace sum(xyz) with $(var1)). 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 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 »