3 Replies Latest reply: Dec 4, 2014 10:58 AM by Jonathan Poole RSS

    Using Variables in Expressions

      Hi Everybody;

       

      as i'm new to QS i'm trying to figure our how variables are used in QS Expressions;

       

      i have successfully created a Variable in the script called "NCDuration"

       

      i tried to create a measure based on this variable in the following manner without success:

       

      Count({$<[NCDuration>30]>}  ReportNumber)

       

      The idea was to count all the existing records >30 days

       

      will highly appreciate any help

        • Re: Using Variables in Expressions
          Jonathan Poole

          Can you post the script command that sets the variable ? 

           

          In SET ANALYSIS , a modifier always references an actual field in the data model like:

           

          Count( {$<DurationField={">30"}>}   ReportNumber)

           

          so if variable = 30 you can pull that in like:

           

          Count( {$<DurationField={">$(NCDuration)"}>}   ReportNumber)

           

          If NCDuration calculates something like Sum(DurationField) then you can reference another field like

           

          Count {$<County={"$(NCDuration)>30"}>}  ReportNumber

           

          ...which would bring back a selection of countries where sum(Duration) by country was > 30 ... and from that selection get you a count of the ReportNumbers

           

          ps:   you may want to do a count(distinct   to only get unique reportnumbers

           

          Anyways post your script command and it may give clues

            • Re: Using Variables in Expressions

              Hi Jonathan and thank you for your prompt answer;

               

              i have added the following line after the LOAD script

              CloaseDate and CreateDate are dates represented as numbers in my file (extracted from a system we have)

              i have checked that the NCDuration set the desired output and it works fine

               

              SET NCDuration=Date(CloseDate,'DD/MM/YY')-Date(CreateDate,'DD/MM/YY')

               

              i will look more closely at your answer to see if i've figure it out

               

              Haim