Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear team.
I have a table with principal and secondary diagnosis:
Type DiagnCode Claim_Id
Principal A 4
Principal A 13
Secondary B 13
Principal A 17
Secondary B 17
Principal A 19
Secondary C 19
Secondary B 19
Secondary D 19
The user should be able to select from list boxes the type(i.e principal) and a diagnosis code (i.e A).
I need to built a table listing all Secondary Diagnosis that are related to the principal.
That is:
DiagnType DiagnCode #ofclaims
Secondary B 3
C 1
D 1
I imagine that this can be done with the use of set analysis, but I am not able to built the proper expression.
Any help will be valuable.
Thank you in advance.
Regards,
Makis.
Hello Makis,
As a final thought, I would experiment with creating a table with separate columns for primary and secondary diagnosis to see if that gives you the behavior you are looking for.
Regards, Karl
Hello Makis,
Here's a quick example that may help.
Regards, Karl
Karl hi and thanks a lot for your prompt help.
Your suggestion helps a lot, but unfortunately is not exactly what I was thinking of. If you select the diagnosis, everything disappears.
I think that something like count(distinct{1-$<Type = >} {1-$<DiagnCode = >} Claim_Id) would be better, but still is not enough.
I need to show all secondary diagnosis related to the primary diagnosis selected by the user (and vise-versa, meaning all primary diagnosis related to the secondary diagnosis selected by the user).
Unfortunately I am new with the company and I probably have to re-invent the wheel 😉
Thanks once more for your help.
Regards,
Makis.
Hello Makis,
As a final thought, I would experiment with creating a table with separate columns for primary and secondary diagnosis to see if that gives you the behavior you are looking for.
Regards, Karl
Hi Karl.
You are absolutely right.
What I did is load 2 new tables holding the associations of primary and secondary diagnosis and vice versa.
Then, by using alternate states, I was able to show what the customer needed.
Thanks once more for your support.
Regards,
Makis.