Sample Scheme and Data for KPI Dictionary
I build a small MYSQL Table to store the following fields:
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: