Posted by William on 24/11/2009 under How To | 
Qlikview creates associations between fields with the same name. Often the use of these fields is limited for the realisation of a descent datamodel. They will never be used by the dashboard designer in the front end. For this reason it’s nice to hide these fields. In order to do this, the first character of all key fields should be the same. In the Qlikview training it’s recommended to use the % sign for keyfields. (example: a keyfield with the name Key becomes %Key).
When all keyfields have a % sign for the first character, it’s easy to hide them in the front end by putting the following command in the END of the script:
SET HidePrefix = %;
When you reload the document and add a new listbox, you will notice the keyfields aren’t there anymore.
Posted by William on 20/11/2009 under How To |
In some situations IIS needs to do the webserver part. With Qlikview 9, the setup for such an environment slightly changed from previous versions. This how to explains to setup Qlikview 9 with IIS on a Windows 2003 machine.
Read more of this article »
Posted by Gilles on 05/11/2009 under News |
Packt Publishing asked me to write a book review about their new book on Oracle Warehouse Builder. Allthough this book is not about Qlikview, you’ll often come accross oracle databases during your Qlikview projects. Since Oracle Warehouse Builder (an ETL tool) comes for free with the database it might come in handy sometimes to use OWB to create yourself an extra data layer from your source databases. This book is a beginnersguide to OWB etl and helps you from the installation of the database and your OWB software till your first deployment. You can read the review here: BOOK REVIEW: ORACLE WAREHOUSE BUILDER 11G – GETTING STARTED
Posted by William on 04/11/2009 under How To |
A common data mining method is Market Basket Analysis. This method checks what kind of items are being sold in combination with other products. It delivers insight in buying behavior which helps to make better deals and, for example, bargain discounts. A famous example discovered this way is the cross selling of beer and diapers in supermarkets. The reason: after the birth of a baby it’s often the father who is buying diapers. Because company know more about their customers trough the use of credit and customer cards, useful information is ready to pick up. The good news: it’s actually quite easy to implement this method in Qlikview.
Read more of this article »