Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jblomqvist
Specialist
Specialist

Which aggregation functions are possible to use in Direct Discovery?

Hi,

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

4 Replies
reddy-s
Master II
Master II

Hi John,

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

Thanks and Regards,

Sangram Reddy.

Anonymous
Not applicable

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/direc...


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

ger_alegria
Partner - Creator
Partner - Creator

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