Direct Discovery - QlikView

[#1]

Hi Friends,

My requirement to have real time reports i.e. my reports should be connected with database, and show the results in real time. Forum I get to know the best to tackle this situation is to use Direct Discovery feature.

But I found plenty of challenges. Did any one used it?

DIRECT QUERY

DIMENSION

  "party_id",agent_name, "role_display_name"

MEASURE

  "role_end_date"

FROM  XXXX.dbo.XXX;

I am displaying above records in table box, but I am unable to export it to excel because role_end_date is used measure, is there any way I can export the measure column as well.

Thanks

Arindam

[#2]

Thanks Jonathan, will be great help, if you get any updates.

[sujeetsingh]

QlikView determines which data resides in-memory and which data is direct discovery data by

using the special script syntax, “DIRECT SELECT”. This syntax allows certain data elements not to

be loaded into the QlikView data model during the script reload process, but still available for

query purposes from the QlikView User Interface and to be combined for analysis with the

QlikView in memory dataset.

Once the direct discovery structure is established, the direct discovery fields can be used with

certain QlikView objects. When a direct discovery field is used on the QlikView object, QlikView

will automatically create the appropriate SQL query to run on the external data source. The

result of the query will be displayed on the QlikView object. When selections are made on the

QlikView application, the associated data values of the direct discovery fields will be used in the

WHERE conditions of the queries. With each selection, the direct discovery charts will be

calculated, where the calculations and aggregations will be done on the source table by

executing the SQL query created by QlikView. It is possible to use calculation condition feature of

the QlikView charts to set a condition indicating when the chart should be calculated. Until that

condition is met, QlikView will not run queries and the chart will not be calculated. Please note

that QlikView will execute SQL queries on the data source for some of the list boxes that use

direct discovery fields. This is required to achieve the associative navigation capability.

[#4]

Thank You Sujeet for explanation.

My problem is in export feature, columns which are in Measures, cannot be exported, understand it is not in the memory, but trying to explore if/ in case there are any possibility to have export feature enabled.

Thanks!