Associating primary and secondary diagnosis

[gmu]

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.

[#2]

Hello Makis,

Here's a quick example that may help.

Regards, Karl

[gmu]

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.

[#4 · Accepted solution]

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

[gmu]

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.