
Contributor
2021-04-29
06:08 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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"
1 Reply

Specialist III
2021-04-29
07:44 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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";
568 Views
