Hey Qlik Sense Community, reaching out because I am at the end of my rope with a particular problem.
In a KPI object in an alternate state, I am attempting to count all possible encounter numbers of patient numbers that are currently selected in the default state. What I have written works great when the selections I have made in the default state are 1-to-1 with the patient number, but when there are multiple instances of the same patient number, Qlik Sense throws out all countable encounters, returning 0 for that count. Here is what I have written:
count(distinct aggr(nodistinct only({$<[Encounter Number]=P([Encounter Number])>}[Encounter Number]),[Patient Number]))))
Imagine the table looks something like:
| [Patient Number] | [Encounter Number] | [Diagnosis] |
| 1357 | 1234 | 470 |
| 2468 | 5678 | 871 |
| 5790 | 9101 | 470 |
| 1256 | 1213 | 470 |
| 2367 | 1415 | 871 |
| 1357 | 1617 | 470 |
| 2675 | 1819 | 234 |
I have selected in the default state the Diagnosis 470. I would expect my KPI to return 4, though it returns 2, as patient number 1357 occurs twice. When I select Diagnosis 871, I return 2, and I select Diagnosis 234, I return 1.
Any thoughts here would be super helpful. I've played around with this for a couple of weeks, but this is as close as I've gotten. I suspect maybe there is a conflict of some sort around the distinct/nodistinct usage, but I have not been able to figure it out.
