Discussion Board for collaboration related to QlikView App Development.
Looking for equivalent of below script in load script.Is it possible.
sum(aggr(sum(DISTINCT [Seats]), [key]))
Group By [key];
You can give name to sum field as well
Sum([Seats]) as SeatsSum
count(distinct [Seats]) as SeatsSum
group by Key;