Building and Using a KPI Dictionary

Sample Scheme and Data for KPI Dictionary I build a small MYSQL Table to store the following fields: Label Definition Description Valid Inside the Definition I use a „special“ syntax, so QlikView won’t crash while loading!

As you can see, I replaced the $-Sign with a §-Sign as the $ would be missinterpreted during the load process! You can easily „replace“ the sign in the load statement! Usage In Expressions u can use it like:

Continue Reading

QlikView Generate Dynamic Variables

Sometimes it could be very usefull to generate variable dynamicaly, in QlikView you can do this easily with a trick inside the load statement of you application! Here is a short example (will give you some examples for a smart usage later):

Continue Reading