Posted by matthew on 15/06/2010 under How To | 
Last week I encountered a few problems with a QlikView app where I had to implement a section access component. The section access needed to fetch the users and roles from an Oracle Database.
Reading through the QlikView Docs I found the chapter about security, explaining an example how to implement it but unfortunately the QlikView Docs aren’t so clear and I had to search through the QlikView forum to find people with similar issues. Read more of this article »
Posted by William on 04/01/2010 under How To |
The ABC-analysis (read more) is an often used method in logistics to divide the product collection in three different degrees, sorted on products with the highest revenue. This analysis gives valuable insights when removing (or adding) products from the collection. Products with low revenue could be considered for removal, cleaning up space in the warehouse for other products.
Read more of this article »
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 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 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 »
Posted by William on 08/10/2009 under How To |
When designing a datamodel in Qlikview, circular reference is quite a common thing.
There are several solutions to prevent such loops like the concatenate function or link table. Although the best solution to fix circular reference depends on the situation, I personally prefer the link table most of the times. When you have two fact tables for example, which shares more then one dimension, it means there is circular reference.
Read more of this article »
Posted by Gilles on 07/10/2009 under How To |
There is a nice post on Qliktips.blogspot.com about how to retrieve a database value within your document without reloading the document.
Read it here: http://qliktips.blogspot.com/2009/10/retrieving-database-values-from-within.html
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 »