Discussion board where members can get started with Qlik Sense.
how i use group by in script i use this but this is not working
(ooxml, embedded labels, table is Sheet1)
group by Account;
Did you want to 'Order By' ?
To use group by in script you need at least a aggr function (SUM,AVG,COUNT)
Count(SubAccounts) as NoOfSubAccounts
Without Aggregation function you will get an error like this
Aggregation expressions required by GROUP BY clause.
Hi, You only need to use the Group by Clause if you are aggregating the information .
For i.e :
COUNT(SubAccounts) as QSubAccounts
That wouldn't give you a error message.
If you express with some detail what you want to achieve we can help you out
If you are just trying to weed out duplicates, you can use DISTINCT
LOAD DISTINCT Acccount,
Group By Account;
Drop Table T1;