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!


In Expressions u can use it like:


Schreibe einen Kommentar