Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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";