topic Re: Sum with distinct ID in QlikView

Sum with distinct ID

apthansh — Wed, 25 Nov 2020 16:16:04 GMT

Looking for equivalent of below script in load script.Is it possible.

sum(aggr(sum(DISTINCT [Seats]), [key]))

Than you.

its_anandrjs — Fri, 29 Sep 2017 19:48:12 GMT

This is

Load DISTINCT

[key],

Sum([Seats])

From Source

Group By [key];

its_anandrjs — Fri, 29 Sep 2017 19:52:25 GMT

You can give name to sum field as well

Load DISTINCT

[key],

Sum([Seats]) as SeatsSum

From Source

Group By [key];

dinuwanbr — Sat, 30 Sep 2017 09:06:01 GMT

Try This

Load

Key,

count(distinct [Seats]) as SeatsSum

from [Source]

group by Key;

Rgds,

Tharindu