Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
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";