We implemented QLIK Sense dashboards with NAVISION as source. In Navision there is a table "Dimension Set Entry" table which has additional information about the Transaction Lines. Additional information such as the BRANCH, DIVISIONS, SECTOR and any such customized information with respect to the Transaction Lines can be added.
The data exists in the table in the following format using 4 columns.
Table: Dimension Set Entry
We were required to add filters on the Dashboard by BRANCH, DIVISIONS, DEPARTMENTS, SECTOR and other such Dimension Codes. The "Dimension Set Id" was linked to the Transaction Lines.
To achieve the above associations we required the data to be in the following format.
We achieved the above using the following script in QLIK Sense (script within *****).
I have just given an example using 4 Dimension Codes. There could be many more.