Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

total by two dimensions in table

Hi

i have the following standard table in Qlik Sense:

AirportRunwayFlightsUsage
LAX24L16080%
LAX24R2010%
LAX25R105%
LAX25L105%
MUC26L15075%
MUC26R5025%

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

1 Reply
MVP
MVP

Re: total by two dimensions in table

Try this

SUM(LegID)/SUM(TOTAL <Airport> LegID)

Community Browser