Adding synonyms

You can create vocabularies for Insight Advisor. This enables you to define terms and values that may be used in questions that are not present in your data model.

If you have Qlik Answers, synonyms can also be used to add terms for Qlik Answers.

You can create vocabularies in Vocabulary under Business logic in the app navigation menu. Vocabularies help improve the success of natural language queries. For example, you can use vocabularies to define:

Alternative names or synonyms for fields, master items, and values.

For example, Earnings, Proceeds, and Revenue for the field Income.
Names for coded values

For example, names for medical classifications codes.
Names for groups of values from a field

For example, defining named age ranges for a field containing ages.
Common acronyms and abbreviations not in the data.

For example, yr for year or num for number.

When you create a vocabulary, you define the terms associated to that vocabulary. You then associate the terms to fields and master items in your app. Optionally, terms can be associated to individual values from the selected fields and master items. The following conditions are available when defining terms for values from fields:

Greater than
Greater than or equal to
Less than
Less than or equal to
In
Not in
In range

The availability of conditions for fields varies depending on the values in the fields.

Vocabularies are created by language for an app. Each language's vocabulary is separate.

The following languages are supported for vocabularies:

English
Dutch
French
German
Italian
Polish
Portuguese
Russian
Spanish
Swedish

Adding terms

Do the following:

In an app, open the app navigation menu and select Vocabulary.
Select a language from the language drop-down.
Click Create terms.
Enter terms for the vocabulary.
Select the field or master item to which the vocabulary applies.
Optionally, select a condition and the values to which the condition applies.
Click Create.

Importing terms

You can upload terms using a XLSX file. The XSLX file requires the use of specific headings and values:

Field: The corresponding field from the application data.
Locale: The language for the term. The following options are available:
- En: English
- De: German
- Es: Spanish
- Fr: French
- It: Italian
- Ja: Japanese
- Nl: Dutch
- Pl: Polish
- Pt: Portuguese
- Ru: Russian
- Sv: Swedish
Terms: The terms for the synonym. Separate terms with ||. For example, clients||customers||users.
Condition Type: Optionally, include the type of condition for the values to which the terms apply.

The available condition types vary depending on the type of values in the field.

Text values:
- In: The field values to which the term applies. Separate multiple values with a comma.
- NotIn: The field values to which the term does not apply. Separate multiple values with a comma.
Numeric values:
- >: Field values greater than the specified number.
- >=: Field values equal to or greater than the specified number.
- <: Field values less than the specified number.
- <=: Field values less than or equal to the specified number.
- InRange: Field values in the specified range. Separate the range values with ||. For example, 0||1000
Information note
Fields containing dates do not support conditions.
Condition Value: Optionally, enter the condition values for which the terms apply.
Master Item: If the field is a master item, enter True.

A sample XSLX file with the headings formatted is available here.

Do the following:

In an app, open the app navigation menu and select Vocabulary.
Click Import.
Select your import file and click Import.
If there are any issues with your import, review the warnings.
Click Finish.

Limitations

Synonyms have the following limitations:

Master items and temporal fields do not support conditions.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here