topic GetSelectedCount Is this a bug? in QlikView

GetSelectedCount Is this a bug?

NickHoff — Thu, 02 Feb 2017 15:15:26 GMT

I have the following logic in a text box that hides once all the criteria is met.

=IF(GetSelectedCount(TopFacility) = 0 And GetSelectedCount(JointSurgeonName) + GetSelectedCount(JointSurgeonNPI) = 0 AND GetSelectedCount(PhysGroups) = 1,'Please select a Facility and Surgeon.',

IF(GetSelectedCount(TopFacility) = 0 And GetSelectedCount(JointSurgeonName) + GetSelectedCount(JointSurgeonNPI) = 0 AND GetSelectedCount(PhysGroups) = 0,'Please select a Facility, Surgeon, and Physician Group.',

IF(GetSelectedCount(TopFacility) = 0 And GetSelectedCount(JointSurgeonName) + GetSelectedCount(JointSurgeonNPI) = 1 AND GetSelectedCount(PhysGroups) = 1, 'Plese select a Facility.',

IF(GetSelectedCount(TopFacility) = 0 And GetSelectedCount(JointSurgeonName) + GetSelectedCount(JointSurgeonNPI) = 1 AND GetSelectedCount(PhysGroups) = 0, 'Plese select a Facility and Physician Group.',

IF(GetSelectedCount(TopFacility) = 1 And GetSelectedCount(JointSurgeonName) + GetSelectedCount(JointSurgeonNPI) = 0 AND GetSelectedCount(PhysGroups) = 1,'Please select a Surgeon.',

IF(GetSelectedCount(TopFacility) = 1 And GetSelectedCount(JointSurgeonName) + GetSelectedCount(JointSurgeonNPI) = 0 AND GetSelectedCount(PhysGroups) = 0,'Please select a Surgeon and Physician Group.',

IF(GetSelectedCount(TopFacility) = 1 AND GetSelectedCount(JointSurgeonName) + GetSelectedCount(JointSurgeonNPI) = 1 AND GetSelectedCount(PhysGroups) = 0, 'Please select a Physician Group',

IF(GetSelectedCount(TopFacility) > 1, 'Please select only one Facility',

IF(GetSelectedCount(JointSurgeonName) > 1 OR GetSelectedCount(JointSurgeonNPI) > 1, 'Please select only one Surgeon',

IF(GetSelectedCount(PhysGroups) > 1, 'Please select only one Physician Group'))))))))))

The layout conditional show is:

GetSelectedCount(Facility) = 0 OR GetSelectedCount(JointSurgeonName) = 0 OR GetSelectedCount(JointSurgeonNPI) = 0 OR GetSelectedCount(PhysGroups) = 0

This works correctly. When i selected mulitple TopFacilty the GetSelectedCount changes to the correct count of selected facilities.

However, once the table

With dimensions JointProcedureType and PhysGroups and the following expression added

Count({1<JointSurgeonName = e(JointSurgeonName), TopFacility = $:: TopFacility, PhysGroups = $:: PhysGroups, JointProcedureType=$::JointProcedureType>}DISTINCT %PatientQVID)

The GetSelectedCount(TopFacility) will show only 1 regardless on the amount of facilities selected.

Is this a bug or is there something wrong with my expression? I'm trying to show all Surgeons except the one selected, ignoring everything but the TopFacility, PhysGroups, and JointProcedureType.

Re: GetSelectedCount Is this a bug?

sunny_talwar — Thu, 02 Feb 2017 16:05:44 GMT

Why would this always be 1?

GetSelectedCount(TopFacility)

I am not completely sure I understand your issue? GetSelectedCount() depends on your selections. If you always have 1 value selected in TopFacility, then it will always be 1. But if you have 0 or more than 1 value selected, why would it be 1?

Would you be able to provide a sample where we can see the issue and what exactly are your concerns

Re: GetSelectedCount Is this a bug?

NickHoff — Thu, 02 Feb 2017 17:43:38 GMT

I wont' be able to share the application complete because the sensitivity of the data. However, I took some screen shots to illustrate what is occurring:

GetSelectedCount(TopFacility) With No Selections:

GetSelectedCount(TopFacility) with one selection prior to meeting the criteria of selecting a surgeon and physician group:

GetSelectedCount(TopFacility) with more than one selection prior to meeting the criteria of selecting a surgeon and physician group:

GetSelectedCount(TopFacility) after meeting the criteria and selecting more than one TopFacility:

Re: GetSelectedCount Is this a bug?

sunny_talwar — Thu, 02 Feb 2017 17:59:59 GMT

Not sure, but how about this?

=If(GetSelectedCount(TopFacility) > 0, Count(DISTINCT TopFacility), 0)

Re: GetSelectedCount Is this a bug?

NickHoff — Thu, 02 Feb 2017 18:09:08 GMT

I was able to get the application scrambled, to reproduce this select horizon for facility, then once the criteria shows select multiple facilities with horizon, the charts should hide however, the top one and the bottom ones data changes and this can't happen. See the attached.

Re: GetSelectedCount Is this a bug?

sunny_talwar — Thu, 02 Feb 2017 18:14:56 GMT

I am not seeing this issue

Regardless of Physician Group, I always see 2 for GetSelectedCount(TopFacility)

Re: GetSelectedCount Is this a bug?

NickHoff — Thu, 02 Feb 2017 18:19:25 GMT

You have to also select a surgeon name, that is part of the criteria to get the charts to display. Everything works correctly until you get the criteria to show then attempt to select stone crest + horizon or vice versa and/or multiple facilities.

Really what i'm looking for is all the charts to hide if the user selects multiple topfacilties. If GetSelectedCount(TopFacility) didnt' show one with multiple facilities selected it would work, but I'm thinking there is a bug somewhere.

Re: GetSelectedCount Is this a bug?

sunny_talwar — Thu, 02 Feb 2017 18:23:09 GMT

Try this:

=If(GetSelectedCount(TopFacility) > 0, Count(DISTINCT{1<TopFacility = $::TopFacility>} TopFacility), 0)

=If(GetPossibleCount(TopFacility) > 0, Count(DISTINCT{1<TopFacility = $::TopFacility>} TopFacility), 0)

Re: GetSelectedCount Is this a bug?

NickHoff — Thu, 02 Feb 2017 18:24:58 GMT

That expression would not help with the data changing on the top and bottom chart when multiple facilities are selected.

Re: GetSelectedCount Is this a bug?

sunny_talwar — Thu, 02 Feb 2017 18:30:20 GMT

Can you share a scenario where it won't work?

Re: GetSelectedCount Is this a bug?

NickHoff — Thu, 02 Feb 2017 18:32:55 GMT

Select Horizon, One Surgeon Name, and One Physician Group. The charts will display correctly.

Once the charts are displayed try to select multiple facilities wtih Horizon.

Re: GetSelectedCount Is this a bug?

NickHoff — Thu, 02 Feb 2017 19:39:08 GMT

Were you able to replicate the bug?

Re: GetSelectedCount Is this a bug?

sunny_talwar — Thu, 02 Feb 2017 19:49:06 GMT

Was in a meeting... checking now

Re: GetSelectedCount Is this a bug?

sunny_talwar — Fri, 03 Feb 2017 00:57:36 GMT

I have a sample ready for you... not sure if you would like me to post it right now or when you are here.... I guess I will wait for you to respond and then attach it.

Best,

Sunny

Re: GetSelectedCount Is this a bug?

NickHoff — Fri, 03 Feb 2017 22:09:20 GMT

Hey Sunny, didn't see your response. I was able to figure this out, there is indeed a bug with the current selection. We've been able to replicate this in multiple apps. It's in the process of being submitted to Qlik. However, the work around we are using is to use TopFacility = p(TopFacility) to get the probable where our calculations won't be affected by the