# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

## More Set Analysis, I think

I use Qlik Sense in a healthcare unit, providing analysis of trauma events.  We use KPIs in a number of areas - average or median time from admission to CT scan, for example.  I chart this using line charts: years on the X axis and hours on the Y axis.  The data is grouped by district health board (DHB).

I'd like to provide the same data, but instead of 5 DHBs I want to show an individual DHB's average plus an average for all five DHBs - so two lines on the chart; one will be coloured for the DHB, and the other grey for the average.  (I can do the colours.)

Can anybody tell me how to make an "all" group and one for the individual DHB?

Steve

1 Solution

Accepted Solutions
Not applicable

## Re: More Set Analysis, I think

hi

attach is a simple example

that when you select one unit display the unit data and the total avg

hope it helps you

6 Replies
Not applicable

## Re: More Set Analysis, I think

hi

attach is a simple example

that when you select one unit display the unit data and the total avg

hope it helps you

Not applicable

Try this

Aggr() function

Not applicable

## Re: More Set Analysis, I think

May be share some raw data if what lironbaram‌ has provided doesn't work for you. It tends to be easier to help if you have data to look at.

Best,

Sunny

Not applicable

## Re: More Set Analysis, I think

Thanks, Liron,

That does the trick.  (I feel slightly dumb for not knowing that I could remove a grouping row to get the average for <All>, then show a single element of the group using a set expression.)

Even your code in Data Load Editor illustrates techniques I've read about but not used.  (Hopefully I wouldn't be expected to use them, as we simply look at lists and chart them.)

Again, thanks,

Steve

Not applicable

## Re: More Set Analysis, I think

Thanks, Rohit,

That's a very useful article - I'll keep it available; it's given me some ideas for future analysis.

Regards,

Steve

Not applicable

## Re: More Set Analysis, I think

Thanks, Sunny,

As I replied to Liron, exploring his data and method makes me feel slightly dumb!  I've spent a couple of days working on it in our environment and producing KPIs in the format we expected.

I'm not (yet) having success with line colouring; auto works as expected but in the original charts I gave each line a specific colour to achieve consistency.  For the moment I'm stuck with red and blue, but I won't give up!

Cheers,

Steve

Community Browser