9 Replies Latest reply: Apr 17, 2012 7:52 AM by nicdepfac RSS

    Alternate states syntax

      Hi,

       

      Could someone explain me the following syntax from the examples in getting started QV11?

       

      num(Sum({[Group 1]<[Product Sub Group]=, Path = $::Path, Region = $::Region, Year = $::Year, Quarter = $::Quarter, Month = $::Month>} Sales)/1000, '#,##0')


      and the corresponding one for the alternate state is

       

      num(Sum({[Group 2]<[Product Sub Group]=, Path = $::Path, Region = $::Region, Year = $::Year, Quarter = $::Quarter, Month = $::Month>} Sales)/1000, '#,##0')

        • Alternate states syntax
          Celambarasan Adhimulam

          Hi,

               From the below expression

               num(Sum({[Group 1]<[Product Sub Group]=, Path = $::Path, Region = $::Region, Year = $::Year, Quarter = $::Quarter, Month = $::Month>} Sales)/1000, '#,##0')

           

          in this part {[Group 1]<[Product Sub Group]=

               Group 1 is alternate state it calculates based on the field selection in that states.

          Path = $::Path

          from this

          $ means default state where you can change it to [Group 2] which is another state.

          $::Path which synchronizes selection with the specified alternate field(here it is default state for the field Path).Its simply like assigns the Default state selection of the field Path to the Path of the Group 1 alternate state.

           

          Celambarasan