How To: Hide Key Fields when Designing QV Application

Posted by William on 24/11/2009 under How To | 2 Comments to Read

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.

How To: Prevent Circular Reference in a Qlikview Data Model

Posted by William on 08/10/2009 under How To | 4 Comments to Read

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 »