Posted by Bas on 19/01/2012 under How To | 
When I develop a QlikView app I use datasources that are local on my PC. For instance my local SQL Server instance has a shrunken copy of the production database. When I deploy the QlikView app to Test I want it to use the datasources that are on the Test machine. When I deploy to Acceptance I want to use the acceptance datasources and of course in Production the real datasources have to be used.
This article describes how I cope with the DTAP (Development, Test, Acceptance, Production) environments in QlikView. Read more of this article »
Posted by Bas on 28/09/2011 under How To |
QlikView offers different document event triggers: OnAnySelect, OnOpen, OnPostReduceData and OnPostReloadData. They all enable you to respond to certain events generated by QlikView. This can be useful in many cases. For instance, I often use the OnOpen trigger to have the current date selected when the user opens the document.
The other day I was developing a QlikView app where I wanted to execute a macro action when the users applied a bookmark. In this case I needed to refresh a chart with different measures that were selected by the user. QlikView does not have an OnApplyBookmark trigger. So how do we persuade QlikView to help us achieve this goal? Read more of this article »
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 »