4 Replies Latest reply: Sep 17, 2016 3:43 PM by Vineeth Pujari RSS

    Concatenated string variable and Set Analysis

    Colin Flynn

      Hello,

       

      I'm having trouble being able to use a variable I have created in my set analysis expression. Please assist. I have tried numerous ways and have not been successful.

       

      Variable Name and Definition:

      vFacilityName = concat(DISTINCT chr(34) & "Facility Name" & chr(34),',')

       

      (When I use my variable (i.e. $(vFacilityName) ) as an expression in a text object, it does work.)

       

      However, I'm unable to do so in my set analysis expression:

       

      Attempt 1: count({$<"Facility Name"={'$(=vFacilityName)'}>}distinct Patient_ID)

      Attempt 2: count({$<"Facility Name"={'$(vFacilityName)'}>}distinct Patient_ID)

      Attempt 3: count({$<"Facility Name"={"$(vFacilityName)"}>}distinct Patient_ID)

      Attempt 4: count({$<"Facility Name"={"$(=vFacilityName)"}>}distinct Patient_ID)

       

      And several other attempts and changing syntax.

       

      Please assist this is definitely giving me some trouble.

       

      Thank you.