3 Replies Latest reply: Jun 4, 2016 5:41 AM by Stefan Wühl RSS

    If condition ?

    Helen Betty

      hi All,

       

      As per the given table , it was in Hierarchical order based on the Dates.

       

      My req is:

      1) if it is Having Actual dates till Tarc in SubDiv, So it is in 'First Stage'.

      2) for example, if it is Having Actual dates till FPEV in SubDiv & LPIV,KEVT are not Enetred, So it is in 'Second Stage'.

       

       

      Div

      SubDiv

      Plan

      Actual

      Gen

      Protocol

      18/12/2015

      29/12/2015

      Gen

      Tarc

      10/01/2016

      03/03/2016

      Gen

      finalization

      12/01/2016

      -

      Gen

      EC

      29/02/2016

      -

      Gen

      FPEV

      05/03/2016

      -

      Gen

      LPIV

      01/09/2016

      -

      Gen

      KEVT

      03/09/2016

      -

       

      As of now Gen (Div) is 'First Stage' based on the Actual.

      Please help me how can i acheive it.

       

      Regards,

      Helen

        • Re: If condition ?
          Stefan Wühl

          Create another field in the script that is linked to SubDiv and describing the stage:

           

          LOAD * INLINE [

          SubDiv, Stage

          Protocol, First

          Tarc, First

          finalization, Second

          Ec,Second

          FPEV, Second

          LPIV, Third

          KEVT,Third

          ];

           

          Then create a chart with dimension Div and expression

           

          =FirstSortedValue( {1} Stage, -Actual)

           

          to show the current stage the Div is in.

           

          Note that Actual dates need to have a numeric representation, i.e. they are correctly interpreted as dates (e.g. by setting the correct format code in the script).