Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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 (3)
1 Solution

Accepted Solutions
agigliotti
MVP
MVP

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

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it

View solution in original post

2 Replies
agigliotti
MVP
MVP

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

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
mphekin12
Specialist
Specialist
Author

Thank you so much!  That seems to work.