Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mphekin12
Specialist
Specialist

Set Analysis Expression Question

Hello,

I have a quick set analysis question.  I'm trying to use a field in a set analysis expression that is also selectable  by the end user.  This is causing errors in the final result.  Here is an example:

mphekin12_0-1592311140070.png

As you can see we have two encounters, one with a visit type of 'Direct' and the other with a visit type of 'Admission from ED'.  The set analysis formula in the blue text box is working as it should.  When I select the visit type of 'Admission from ED', I would think that the set analysis formula in the blue text box would display 0, but it is still displaying 1 even though there is no longer a Direct visit type in the set:

mphekin12_1-1592311306427.png

I'm sure there is probably an easy solution for this but I can't seem to figure it out. 

 

Thank you for your help!

Labels (2)
1 Solution

Accepted Solutions
agigliotti
Partner - Champion
Partner - Champion

Hi,
You should use VISIT_TYPE * =  instead  of   VISIT_TYPE =

View solution in original post

2 Replies
agigliotti
Partner - Champion
Partner - Champion

Hi,
You should use VISIT_TYPE * =  instead  of   VISIT_TYPE =

mphekin12
Specialist
Specialist
Author

Thank you so much!  That seems to work.