Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i have the following standard table in Qlik Sense:
Airport | Runway | Flights | Usage |
---|---|---|---|
LAX | 24L | 160 | 80% |
LAX | 24R | 20 | 10% |
LAX | 25R | 10 | 5% |
LAX | 25L | 10 | 5% |
MUC | 26L | 150 | 75% |
MUC | 26R | 50 | 25% |
What I need is the Usage per Runway per Airport. Airport and Runway are dimensions.
Flights = SUM(LegID).
For Usage I tried with: SUM(LegID)/AGGR(SUM(Total LegID),Airport). However didn't get the expected result.
Any idea... maybe something with rangesum/above?
Brgds Ralf
Try this
SUM(LegID)/SUM(TOTAL <Airport> LegID)