Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Qqqqqq
Contributor
Contributor

Qliksense data load editor script aggregation syntax?

I'm trying to do a simple aggregation in the Qliksense data load editor. However, this results in an error. Is there a particular Qlik syntax to follow to achieve this?

Load
"var_1",
"var_2",
"var_3",
"agg"

SQL select "var_1", "var_2", "var_3", sum("var_4") as "agg"
from table
groupby "var_1", "var_2", "var_3"
Labels (1)
1 Reply
jwjackso
Specialist III
Specialist III

I don't know if you left out a semi-colon and in some databases, it is "group by".  

 

Load
"var_1",
"var_2",
"var_3",
"agg";<-Missing semi-colon

SQL select "var_1", "var_2", "var_3", sum("var_4") as "agg"
from table
group by "var_1", "var_2", "var_3";

 

If you still get an error, try just "Load *;" to see how the fields are being passed to Qlik.

 

Load *;
SQL select "var_1", "var_2", "var_3", sum("var_4") as "agg"
from table
group by "var_1", "var_2", "var_3";