topic Re: Which aggregation functions are possible to use in Direct Discovery? in App Development

Which aggregation functions are possible to use in Direct Discovery?

jblomqvist — Mon, 04 Jan 2016 09:41:27 GMT

Hi,

Can anybody please tell me which aggregation functions are possible to use in Direct Discovery?

Re: Which aggregation functions are possible to use in Direct Discovery?

reddy-s — Mon, 04 Jan 2016 14:05:32 GMT

Hi John,

You can only use MIN,MAX,SUM,COUNT and AVG Functions.

Thanks and Regards,

Sangram Reddy.

Re: Which aggregation functions are possible to use in Direct Discovery?

Chanty4u — Tue, 05 Jan 2016 06:16:17 GMT

hi,

https://community.qlik.com/blogs/qlikviewdesignblog/2014/05/19/function-classes

hope this helps u

Re: Which aggregation functions are possible to use in Direct Discovery?

Anonymous — Fri, 21 Apr 2017 14:00:53 GMT

This comes from the Qlik Sense help:

You can find more information here: https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/Scripting/ScriptRegularStatements/direct-discovery-field-li…

Direct Discovery does not support using aggregations in LOAD statements. If aggregations are used, the results are unpredictable. A LOAD statement such as the following should not be used:

DIRECT QUERY DIMENSION stateid, SUM(amount*7) AS MultiFirst MEASURE amount FROM sales_table;

The SUM should not be in the LOAD statement.

Direct Discovery also does not support Qlik Sense functions in Direct Query statements. For example, the following specification for a DIMENSION field results in a failure when the "Mth" field is used as a dimension in a visualization:

month(ModifiedDate) as Mth

Re: Which aggregation functions are possible to use in Direct Discovery?

ger_alegria — Fri, 21 Apr 2017 14:43:21 GMT

You can use Sum, Avg, Count, Max, Min.