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:

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):