Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Were you able to replicate the bug?
Was in a meeting... checking now
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
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