Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Sum when ID is distinct

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)

- 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?


1 Reply
Champion III
Champion III

try this


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