What is Direct Discovery ?? And how it used ?? Can anyone give me an example of how using Direct Discovery ?

[nikhilgarg]

Hey,

What is Direct Discovery ?? And how it used ?? Can anyone give me an example of how using Direct Discovery ?

Thanks

[sujeetsingh]

Follow this document word by word

QlikView Direct Discovery FAQ 11.2 SR7.pdf

[Kushal_Chawda]

Please see the below link

http://community.qlik.com/docs/DOC-5534

[ashfaq_haseeb]

Hi,

Check this too.

http://community.qlik.com/docs/DOC-6916

Regards

ASHFAQ

[avinashelite]

Hi Nikhil,

Direct Discovery is a method using which we can bring the real time data to the QV dashboard.

Please refer this pdf.

[jagan]

Hi Nikhil,

Direct Discovery is used for real time analysis in Dashboards.  For example you take share market, every minute the share values are keep on changing to see the changes in Dashboard as and when it changes Direct Discovery is very useful. 

Syntax of Direct Discovery is

DIRECT QUERY

DIMENSION

Dimension1,

Dimension2,

Dimension3

MEASURE

Measure1,

Measure2,

Measure3

FROM TableName;

Which is similar to in SQL

SELECT

Dimension1,

Dimension2,

Dimension3,

Measure1,

Measure2,

Measure3

FROM TableName;

Hope this helps you.

Regards,

Jagan.

[nikhilgarg]

Hey ,

It means if data is very large and it takes time to load to qlikview then we can use direct discovery which not loads the data in qlikview but make a connection to datasource and fetch data from there directly. Am i ryt ??

And also we have seen dimensions and expressions. What is measure ??

Thanks

[avinashelite]

A measure field is a field that QlikView is aware of on a “meta level”. The actual data of a measure field

resides only in the database during the reload process and is retrieved on an ad hoc basis driven by the

QlikView front end chart expressions. The idea is that a measure field will be treated as any other field

when the user works with expressions in QlikView. The reason to introduce the concept of measure

fields is for QlikView to decide if an aggregation should be done on the database instead of being

processed by QlikView itself. For example, if the expression Count(Address) is used in a QlikView chart

and Address is a measure field, QlikView will let the database do the count (obviously since QlikView

doesn’t have any data for the Address field). To put it in another way; measure fields will add support

for aggregating in the database while using the same expression syntax QlikView already has. The

result is that the usage of the direct discovery fields from the database will be transparent for the user.

[jagan · Accepted solution]

Hi,

Yes we can load dynamic data directly in the background using DIRECT DISCOVERY.  Measures are the value fields like Sales, Qty, Discount etc.

Hope this helps you.

If you got the solution close this thread by giving Correct and Useful answers.

Regards,

jagan.

[nikhilgarg]

Hey,

In short you mean to say Field used in Expression tab are measure. Is it so ??

Thanks