Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
lailarhc
Creator
Creator

Average line based on expression values instead of straight reference line

I have a line chart like this:

lailarhc_0-1642095489891.png

 

Where Dimension 1 is a drill-down dimension with Year and month.

Dimension 2 is the name of each employee:

=NomeEmpregado

 

And the measure represents how many courses each employee has taken:
=count( distinct {<Tipo={'Turmas'}, lotatual={"000075"} >+< lotatual={"00075*"}>} if(IsNull(DataSaidaEmpregado) and (Not isNull(CodEvento)), CodEvento & '|' & CodEmpregado))

 

I need to add an average permanent line based on an expression value, not a straight reference line.

This is the line graph with the average courses per employee each year:

lailarhc_1-1642095816511.png


I want to add this average line to my first graph, so that I have this average line as a permanent feature, no matter the selection. It needs to be always there so I can compare how many courses an employee has taken against the average numbers of courses per employee in a given period of time.

How can I accomplish this?

0 Replies