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 Reply

Create your own website, free on WordPress.com.Create your own website.
Start free