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!
|
1 |
count({§<ActionType={"UnitMoveout"}>}%ActionID) |
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:
|
1 |
$(=only({<KPI.Label={"Contacts"}>}KPI.Definition)) |