Sum when ID is distinct

brunolelli87 — Mon, 05 Apr 2021 18:28:23 GMT

Hello guys,

I'm using the following expression ir order to count how many different aircraft are flying at the same time:

count({<DASI ={'$(vData3)'},NCIA={'GLO'},ONGR={'0'}>} DISTINCT KEYI)

Where,
- DASI is a Date Field (DD/MM/YY)
- NCIA is the airline
- ONGR is 0 or 1
- KEYI is a distinct ID for each aircraft

And my Dimension is Time (HH:MM):

Now, I would like to sum the available number of seats per time, using Time as dimension, but showint the sum of Seats per airline...
How can I do that?

Re: Sum when ID is distinct

Chanty4u — Tue, 06 Apr 2021 10:46:51 GMT

try this

sum(aggr(count({<DASI ={'$(vData3)'},NCIA={'GLO'},ONGR={'0'}>} DISTINCT KEYI),KeYI))

topic Sum when ID is distinct in QlikView

Sum when ID is distinct

Re: Sum when ID is distinct