Set Analysis Expression Question

mphekin12 — Sat, 16 Nov 2024 00:28:15 GMT

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:

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:

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!

Re: Set Analysis Expression Question

agigliotti — Tue, 16 Jun 2020 13:09:35 GMT

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

Re: Set Analysis Expression Question

mphekin12 — Tue, 16 Jun 2020 13:26:57 GMT

Thank you so much! That seems to work.

topic Re: Set Analysis Expression Question in QlikView

Set Analysis Expression Question

Re: Set Analysis Expression Question

Re: Set Analysis Expression Question