1 Reply Latest reply: Oct 12, 2012 6:31 PM by Erich Shiino RSS

    How to display if selected?

      I have a calendar conrol in my script and a list box in my application showing the Quarter.  The values in the list box are 1,2,3, & 4.  For a calculated dimension, I want to show some data based on the selection of the quarter in the list box.  For example, if the quarter selected = 3, then show X, if the quarter = 4 then show Y, etc.


        • Re: How to display if selected?
          Erich Shiino

          Hi, Sean

          You use an if expression based on this field.

          Let us say the field is called 'Quarter'

          You can use this as an expression

          =If ( Quarter = 3, X,

               if( Quarter = 4, Y)) )


          where X and Y can be any expresion.

          This is will only work if only one value in the list box is selected. To achieve it, you can go to the list box properties, general tab and check 'one selected value'  ( you need to select one value there first)


          Hope this helps,