Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
GiuQlik7
New Contributor II

Combined chart and data aggregation

Hi, I'm continuing to play with this fascinating tool and I thought of a chart to be obtained 
by aggregating data. In practice I have available the distribution of the values ​​of a dimension and I would like
to obtain in addition to this distribution also the average trend or the sum of all the detail
values.
I show an example obtained by simplifying my idea with excel.

grafico sovrapposizione.jpg
Obviously I would like to get a single chart combinated.
can you advise me on how to aggregate data? 
I have to do this with the data load editor or I can get the graph directly using the functions 
in the sheet analysis? 

Thank you! 🙂

Labels (3)