6 Replies Latest reply: Jun 9, 2017 2:35 AM by Nikos Tsachalis RSS

    Max value of measure in pivot table

    Nikos Tsachalis

      Hi all,


      I have recently discovered Qlik and I am stuck with the following:


      I have created a pivot table with dimensions 'Resource' and 'CollectionTime' (The granularity of the collected data is 15 minutes). The measure is 'Outbound Rate'.

      I am trying to find the busy hour. For this I have created a new measure as follows:


      RangeSum(Above([Outbound Rate],0,4))


      However I am stuck in find the max value of the above. The goal is to find the busy hour (max of the above measure) per interface.

      I have used  rangemax(RangeSum(Above([Outbound Rate],0,4)),Resource,CollectionTime) but it reports the same as RangeSum(Above([Outbound Rate],0,4)).

      Any help is much appreciated.

      Thx in advance


      PS I am using Qlik Desktop.