4 Replies Latest reply: Aug 26, 2014 11:13 AM by Anurag Gupta RSS

    How to select Select Next Row ?


      Hi All,

       

      Can someone guide me how to do this(mentioned below) type of calculations ?

       

      Input Data Format for any month

      Employee IDLevel
      101EE
      102EE
      103EE
      104TL
      105TL
      106EE

      107

      EE
      108EE
      109EE
      110AM
      111MGR

      Seniority in level : MGR>AM >TL> EE

       

      How i want to display Output table in QlikSense

       

      LevelHeadcountSupervisory RatioSpan of Control
      MGR117
      AM127
      TL23.53.5
      EE7

      Supervisory Ratio for TL  :  Count Level(EE)/Count (TL)

      Supervisory Ratio for AM  :  Count Level(TL)/Count (AM)

      Supervisory Ratio for MGR  :  Count Level(AM)/Count (MGR)

       

      Span of Control for AM : Count Level(EE)/Count (AM)

      Span of Control for TL : Count Level (EE)/ Count(TL)

      Span of Control for TL : Count Level (EE)/ Count(MGR)

       

      For Span of control - Numerator will always be count Level( EE)

       

      Thanks

      Anurag Gupta