What is wrong with this aggr()?

[#1]

Hi Qlik Helpers,

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')

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 wronge if both treatments are selected.

Appreciate all your help.

Regards

[#2]

Hi,

Those are the dimensions on the pivot (please check the qvw - aggr issue3).

Treatment Duration is the same as months of treatment per treatment types, and Treatment Types are the treatments themselves.

I'm not sure I understood correctly what are you asking for

Regards

[#3]

Any luck on this issue????

Thanks

Regards