Qlikview

Avoid Synthetic Keys: Qualify

Leave a comment

Qualify keyword comes into use when a synthetic key is generated due to data modelling issue.

When Qualify word is specified in the script, application maintains the full fledged names across the columns:

qualify1

Below is the Data Model created after the reload:

qualify

If we want to qualify specific column we can provide the column name instead of *.

More than one column name can be comma separated.

Leave a comment

Design a site like this with WordPress.com
Get started