topic Combine Alternate States in one chart in QlikView

Combine Alternate States in one chart

Tue, 22 May 2012 13:57:17 GMT

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

Combine Alternate States in one chart

Anonymous — Tue, 22 May 2012 14:15:45 GMT

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

-Phil

Combine Alternate States in one chart

Wed, 23 May 2012 07:14:33 GMT

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

/Mikael

Combine Alternate States in one chart

Wed, 23 May 2012 07:19:53 GMT

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

Re: Combine Alternate States in one chart

Anonymous — Thu, 16 Aug 2012 13:56:45 GMT

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)

Re: Combine Alternate States in one chart

phcaptjim — Mon, 25 Aug 2014 12:31:11 GMT

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!

Re: Combine Alternate States in one chart

heitzmarcel — Fri, 15 Dec 2017 08:44:15 GMT

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