1 Reply Latest reply: Oct 12, 2017 7:47 PM by Sunny Talwar RSS

    total by two dimensions in table

    Ralf Schulz

      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