Dictionary Lookups

Use this feature to create lookup tables.

The high level sequence for creation is:

Manage Tab

Step-by-step guide

1. In the Manage Tab click on the New or Edit links to create a new lookup table or edit an existing lookup table

2. Enter the following data for the descriptive information of this lookup table:

• Name: the dictionary entry

• Description: freeform text description of the lookup table

• To Item: this is the field name if you use the lookup table in a Qlik Sense mapping load.  When you applymap this name to a field, the field will be renamed as the "To Item" name

• Default Value (optional): is a default value for values that are not mapped in the Dictionary Lookup Values

• Governance: associated Governance item (future use)

• Tags (optional): any metadata tags for easy searching

• Notes (optional):  freeform text for notes

3. Click to apply the changes.

Open

Import Data Tab

Use this feature to import lookup values from a MS Excel workbook.

Open

Step-by-step guide

1. Click on the template link

2. open the MS Excel workbook and find two sheets

   1. Sheet named "Lookup" has the same fields as described in the definition screen above - you can import multiple entries into the dictionary

   2. Sheet named "LookupValues" has the same fields described in Dictionary Lookup Values in this help document

3. Make any entries and save the MS Excel workbook

4. From the Import Data Tab, browse for the file you updated and upload it

5. The processing messages is followed by a success message

Linked Dictionary Entries Tab

Use this feature to list all Lookup Tables that have been associated with Dictionary Entries and selectively delete unwanted associations.

Associate Dictionary Entries Tab

Use this feature to associate a Dictionary Lookup table that you have created to a specific Dictionary Entry.

Step-by-step guide

1. In the left table, choose a Dictionary Lookup Name by selecting the check box for the name you want to associate

2. On the right side, select the Dictionary you want from the drop down list (ex "CDW")

3. Select the check box for the Dictionary Entries that should be associated with the Lookup Table

4. Click the 

   button to make the association

Using the Code Snippet to help you with a Mapping Load in Qlik Sense

• On the Manage tab, click on the 

   button

• A .txt file is dropped in your browser's default download folder

• open codesnipet.txt 

• find code that you can copy and paste into the load script of a Qlik Sense application

example:

Related articles