7 Replies Latest reply: Feb 15, 2013 5:40 AM by Manideep Hv RSS

    Let statement as set statement

    Sandeep Hamelink

      Dear QV-users,

       

      i would like to have the result of this formula as a set statement

       

      RangeCount

      (count(

      {$<

          
      LeerlingRecordId =

      {
      "=

      SUCCESVOL = '1'     


      "
      }

      >}

      DISTINCT LeerlingRecordId),BEKOSTIGD,OMVANG_OPLEIDING,Gecorrigeerde_Uitschrijving,KWALIFICATIE_NIVO,VERBINTENIS_NUMMER)

       

       

      ___

       

       

      for example:

       


      LET test = '

       

      RangeCount

      (count(

      {$<

          
      LeerlingRecordId =

      {
      "=

      SUCCESVOL = '1'     


      "
      }

      >}

      DISTINCT LeerlingRecordId),BEKOSTIGD,OMVANG_OPLEIDING,Gecorrigeerde_Uitschrijving,KWALIFICATIE_NIVO,VERBINTENIS_NUMMER)

       

       

       

      '


      SET test2 = test

       

       

      When i use Set as expression i would like to see the result of the formula i use above.

       

      Gr. Sandeep

        • Re: Let statement as set statement
          Manideep Hv

          Ofcourse you can use  SET test2 = test;

            • Re: Let statement as set statement
              Sandeep Hamelink

              Unfortunately this is not what i ment. i will give you a more simple example of what i want

               

              SCRIPT:

               

              LET  FORMULE = 7 + 1 ;

               

              SET  FORMULE2 = FORMULE

               

              When i look at my settings -  variables i would like to see at variable FORMULE2

              NOT

               

              FORMULE2 = FORMULE, but

               

              FORMULE2= 8

               

              when it comes to my real situation i don't want to see at settings - variables

               

              TEST2 =

               

               

              RangeCount(

                  count({$<LeerlingRecordId={"=SUCCESVOL='1'"}>} DISTINCT LeerlingRecordId)

                  ,BEKOSTIGD,

                  OMVANG_OPLEIDING,

                  Gecorrigeerde_Uitschrijving,

                  KWALIFICATIE_NIVO,

                  VERBINTENIS_NUMMER) ;

               

              BUT

               

              TEST2 = 82

              Gr. Sandeep

            • Re: Let statement as set statement
              Sandeep Hamelink

              Unfortunately this is not what i ment. i will give you a more simple example of what i want

               

              SCRIPT:

               

              LET  FORMULE = 7 + 1 ;

               

              SET  FORMULE2 = FORMULE

               

              When i look at my settings -  variables i would like to see at variable FORMULE2

              NOT

               

              FORMULE2 = FORMULE, but

               

              FORMULE2= 8

               

              when it comes to my real situation i don't want to see at settings - variables

               

              TEST2 =

               

               

              RangeCount(

                  count({$<LeerlingRecordId={"=SUCCESVOL='1'"}>} DISTINCT LeerlingRecordId)

                  ,BEKOSTIGD,

                  OMVANG_OPLEIDING,

                  Gecorrigeerde_Uitschrijving,

                  KWALIFICATIE_NIVO,

                  VERBINTENIS_NUMMER) ;

               

              BUT

               

              TEST2 = 82

              Gr. Sandeep