topic Re: Concatenated string variable and Set Analysis in QlikView

Concatenated string variable and Set Analysis

Fri, 16 Sep 2016 22:48:29 GMT

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.

Re: Concatenated string variable and Set Analysis

swuehl — Fri, 16 Sep 2016 23:11:36 GMT

It may depend on how you defined your variable, with or without a leading equal sign:

vFacilityName

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

Then

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

should work, IMO.

Create a straight table chart with this expression and Facility Name as dimension and then hover with the mouse over the expression header. It should show the expression with the variable expanded.

Re: Concatenated string variable and Set Analysis

Anil_Babu_Samineni — Sat, 17 Sep 2016 03:31:56 GMT

What are the values of facility name

Re: Concatenated string variable and Set Analysis

Sat, 17 Sep 2016 04:13:07 GMT

Values of Facility Name field were: Hospital 1, Hospital 2, etc...

Values of Variable were: "Hospital 1", "Hospital 2", etc.

Re: Concatenated string variable and Set Analysis

vinieme12 — Sat, 17 Sep 2016 13:20:41 GMT

variable

=concat(DISTINCT chr(34) & [Facility Name] & chr(34),',')

Expression

=count({$<[Facility Name]={$(vFacilityName)}>}distinct Patient_ID)