3 Replies Latest reply: Feb 21, 2013 6:57 AM by Jagan Vijayakumar RSS

    function equal to inline

    Jagan Vijayakumar

      Hi all,

       

      I have the following data

       

      DateABC
      111631
      221732
      331833
      441934
      552035
      662136
      772237
      882338
      992439
      10102540
      11112641
      12122742
      13132843
      14142944
      15153045

       

      I want to create a chart like the one shown below

       

      test.bmp

       

      I used an Inline function to create the column FY in the chart.

       

       

      LOAD

       

      * INLINE [
      F1
      Rev
      Vol
      eVol
      ]

      ;

       

      expression used in column name 1 in the chart was

      .

       

      IF(F1='Rev',Sum({< Date={1}>} A),

      IF(F1='Vol',Sum({< Date={1}>} B),

      IF(F1='eVol',Sum({< Date={1}>}C)

        )))

       

       

      I want to know the equivalent function for the inline function at the ui side inorder to create a dummy values for a column that can be used in charts.

      Please advice.

      I have also attached the file.

       

      Thanks in advance.