The Spotfire Community is moving to TIBCOmmunity and this forum location has closed. During the transition, you can still search the old forums but posting has been disabled. We encourage you to pick up the discussion at the new Spotfire community on TIBCOmmunity.
Calculated Column expression over multiple rows - TIBCO Spotfire Community

Calculated Column expression over multiple rows

Last post Fri, Aug 2 2013 1:33 AM by Melody. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • Mon, Oct 3 2011 5:30 AM

    Calculated Column expression over multiple rows

    I'm building a custm expression for a Calculated Colomn. This works fine when I use the data from the same row, but I need to use an if-statement where i checks if some value is used in one of the rows of a certain column. In other languages I would use a while of foreach statement. How could I achieve this in spotfire professional?
  • Tue, Oct 4 2011 4:46 AM In reply to

    Re: Calculated Column expression over multiple rows

    Hi,

    you could try to use the "over" statement to calcualte over a certain category.

    The OVER functions are used to determine how data should be sliced, for example, relative to time periods. For more information, see OVER in Custom Expressions and Advanced Custom Expressions.

    Christof

    -----------------------------------
    Dr. Christof Gaenzler
    Sr Solutions Consultant
    TIBCO Spotfire
  • Wed, Oct 12 2011 4:35 AM In reply to

    Re: Calculated Column expression over multiple rows

    Thanks! The OVER functions did the trick.
  • Tue, Jun 18 2013 9:56 PM In reply to

    • Rayees
    • Not Ranked
    • Joined on Fri, Mar 15 2013
    • Posts 2

    Calculated Column expression Using OVER Statement.

    HI Christoff ,
    I Do have a Situation over here to do a custom Expression.

    Please Let me know what Custom Expression, I can put in over here to solve the issue.

    Date   Country   Sales   Expected Output
    01-Jan-2013   Germany   1000   1000+2000
    01-Jan-2013   Germany   2000   1000+2000
    01-Jan-2013   Russia   5000   5000
    01-Jan-2013   India   9000   9000+3500
    01-Jan-2013   India   3500   9000+3500
    02-Jan-2013   Germany   1500   1500+2500
    02-Jan-2013   Germany   2500   1500+2500
    02-Jan-2013   India   7500   7500+2000
    02-Jan-2013   India   2000   7500+2000
    03-Jan-2013   Germany   2000   2000
    03-Jan-2013   Russia   3000   3000+5000
    03-Jan-2013   Russia   5000   3000+5000
    My custom Expression should help me to find the trend for each day.
    For Day 1 (01-Jan-2013) Sum of Total Sales for each Country for each day. Like mentioned in the Expected Output
    can this be solved by OVER expression........?
    Please Solve this ASAP and Big thanks in Advance
    Regards,
    Rayees
    Software developer in hp
  • Fri, Aug 2 2013 1:33 AM In reply to

    • Melody
    • Not Ranked
    • Joined on Fri, Aug 2 2013
    • Posts 3

    Re: Calculated Column expression over multiple rows

    Pour cela, vous avez été le partage de nos lecteurs, je veux juste vous dire merci. Merci de poster ce sujet. lunettes de soleil ray ban Armani lunettes de soleil
Page 1 of 1 (5 items)
©Copyright 2000-2011 TIBCO Software Inc | Privacy Policy | Terms of Use I Blog I Contact Us I Content Center