What is qlikview direct discovery

See Caching and Direct Discovery below. While detached fields are not queried for associations, they are still part of the filters, speeding up selection times. Qlik Sense in-memory fields keep only one copy of a field value when there are multiple instances of the same value.

However, all field data is loaded, and then the duplicate data is sorted out. DIMENSION fields also store only one copy of a field value, but the duplicate values are sorted out in the database before they are loaded into memory.

Direct Discovery selects data from source databases according to the case-sensitivity of the database fields queried. If the database fields are not case-sensitive, a Direct Discovery query might return data that an in-memory query would not. For example, if the following data exists in a database that is not case-sensitive, a Direct Discovery query of the value "Red" would return all four rows.

An in-memory selection of "Red," on the other hand, would return only:. Qlik Sense normalizes data to an extent that produces matches on selected data that databases would not match. As a result, an in-memory query may produce more matching values than a Direct Discovery query. For example, in the following table, the values for the number "1" vary by the location of spaces around them:.

If you select "1" in a Filter pane for ColumnA , where the data is in standard Qlik Sense in-memory, the first three rows are associated:. The matches returned for Direct Discovery data depend on the database. The measure fields require to have an aggregation function. Columns followed by Detail are also part of the source table and are NOT loaded in memory.

These columns do not require aggregation. They are displayed only in the QlikView table box. Columns after Detach will be loaded in memory and are used to flag columns that should not be part of the associative experience but will be part of the query passed to the data source. QlikView direct discovery is a very useful feature. It is useful when you have to load a large table. As you know QlikView is in-memory and each unique field utilizes memory.

With direct discovery, you have the option to use a large database table without losing the associative feature. Further Reading : Qlik Design Blog.

Your email address will not be published. Save my name, email, and website in this browser for the next time I comment. Notify me of follow-up comments by email. Notify me of new posts by email. This site uses Akismet to reduce spam. Learn how your comment data is processed. Your articles and tutorials Vinoth: We provide QlikView Training. This training will Excellent training by Chandraish. Highly knowledgeable. It is not designed to be a real-time solution.

To learn more about limitations, see Limitations when using Direct Discovery. Qlik Sense on-demand apps provide a more flexible approach to loading and analyzing big data sources. To learn more about on-demand apps, see Managing big data with on-demand apps.

Selections can be made on in-memory and Direct Discovery data to see associations across the data sets with the same Qlik Sense association colors - green, white, and gray.