Combine Alternate States in one chart

[#1]

Hi,

I would like to create a bar chart that displays the result of two different alternates state selections. I would like to have one bar for each group.

How do I do this? When looking at properties for the chart object, I can select only one group on the general page but if I do this I can only see one of the selections.

We did this as a exercise on the QV Development training but I can´t remember how....

Regards,

Mikael

[Anonymous · Accepted solution]

An Alternate State can be specified in Set Analysis, e.g.:
sum({[Group 1]} Sales)

-Phil

[#3]

Aahh, that´s the trick. Thanks for the rapid response.

/Mikael

[#4]

Hey Phil,

I to have some doubts, will you kindly look at them and through some light on it. I will be very greatful to you for the same.

Regards

Sagar Gupta

[Anonymous]

How do you do if you want to have the alternate state, like in the answer - for example sum({[Group 1]} Sales) - and then also filter by say, country = Africa ? (country belongs to the Group 1 state also)

[phcaptjim]

How would you write an expression that wanted to do something like this:

sum({[Group 1],[Group 2],[Group 3]} Sales)

The following expression works but it requires the ID to be in all three alternate states:

Max({Cohort1}{Cohort2}{Cohort3}PatientID)

This will return the patient ID for those that exist in all three alternate states (Cohort1,Cohort2,Cohort3).

Is it possible to write an expression that returns PatientID for those that appear in ANY state instead of EVERY state?

Thanks!

[heitzmarcel]

Just had the same Questions you had and your input helped me a lot. Thanks.

Knowing this is 3 years old, but still if someone looks for the same solution:

Aggr(Only({Cohort1/Cohort2/Cohort3}PatientID),PatientID)

/ needs to be replaced by * when there is no selection in the following state.

This Expression will return you a List of all PatientIDs selected in one of the 3 States.

Best Regards,

Marcel