Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
brunolelli87
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)

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?

 

1 Reply
Chanty4u
Champion III
Champion III

try this

 

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