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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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";