5 Replies Latest reply: Sep 10, 2017 1:25 AM by rohit raut 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

        • Re: How to select Select Next Row ?

          I would add another field to your source to assign the hierarchy for each Level, then you can use the same field for any of your calculations above.

          • Re: How to select Select Next Row ?
            rohit raut

            Hello Anurag,

             

            Try this,

             

            Creat a straight table.

             

            Dimension = Level

             

            Expression :

             

            1)For Headcount:

            Count(Level)

             

            2)Supervisory Ratio:

             

            If(Level='TL', (count({<Level={'EE'}>}Level)/

            count({<Level={'TL'}>}Level)),

                 

            If(Level='AM', (count({<Level={'TL'}>}Level)/

            count({<Level={'AM'}>}Level)),


               

            If(Level='MGR', (count({<Level={'AM'}>}Level)/

            count({<Level={'MGR'}>}Level))

            )))

             

             

             

            3) Span of control :

             

            If(Level='AM', (count({<Level={'EE'}>}Level)/

            count({<Level={'AM'}>}Level)),

                

            If(Level='TL', (count({<Level={'EE'}>}Level)/

            count({<Level={'TL'}>}Level)),


               

            If(Level='MGR', (count({<Level={'EE'}>}Level)/

            count({<Level={'MGR'}>}Level))

            )))

             

             

             

            Hope this helps!