Hi,
I'm having an issue with an aggregation expression that doesn't fetch the expected results.
Issue summary:
1 - I'm looking at patients behaviour related to a treatment type (T1 and T2);
2 - Patients may have 2 different categories or status: Naive patients ('N') and experienced patients ('E')
4 - I'm interested to capture the Naïve patients only (Patient Status ='N') and understand for how many periods their treatment lasts.
3 - I want to count the distinct patients distribution over the treatment lifespan (Treatment Duration), by each Treatment Type and provided they have a record as Naïve patients ('N') at one of the periods available.
The expressions reads ok if I select a single treatment type but it is wrong if both or all treatments are selected.
Example:
- For Therapy 1 the result is 973 and for therapy 2 the reading is 600. Both results are ok.
- But take a close look to what happens on month 2 when you select each of the therapies available in the listbox and when you selec none of them.
- In the pivot table you'll find the different results that are fetched.
- If you select T1 (on therapies listbox) you have precise results all over the treatment duration periods, i.e.,
M1 - 973
M2 - 877
M3 - 834
, but if you select both therapies, or none, the result that is fetched for T1 is the following:
M1 - 973
M2 - 887
M3 - 843
My believe the reason for this behaviour lies on the P() parameter within the set analysis which does not take in consideration, for the set members, the therapy segments it should consider to form each bucket of patients.
Could you please take a look to the qvw attached and advise what could be a possible solution for this?
Kind regards
