Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How do i add a reference line that is an expression. I would like to include an average from a subset of data.

How do i add a reference line that is an expression. I would like to include an average from a subset of data.

For example I have a set of data that consists of network operators and every network operators offers 3G and 4G services. I would like the reference line to be a measurement of a network operator for its 3G service.

How am I able to do so?

6 Replies
MVP
MVP

Re: How do i add a reference line that is an expression. I would like to include an average from a subset of data.

Maybe like

=Avg( {<Service = {'3G'} >} MeasureField)

awhitfield
Esteemed Contributor

Re: How do i add a reference line that is an expression. I would like to include an average from a subset of data.

Hi Wei Chong,

are you able to unload any example source data or a sample QVW?

Andy

Not applicable

Re: How do i add a reference line that is an expression. I would like to include an average from a subset of data.

Hi,

my apologies for not stating clearly. I am actually using qlik sense and not qlik view

Not applicable

Re: How do i add a reference line that is an expression. I would like to include an average from a subset of data.

OK I will try that and let you know if that works! Thank you!

Not applicable

Re: How do i add a reference line that is an expression. I would like to include an average from a subset of data.

Oh yes, any idea where can i find documentation on t?

Not applicable

Re: How do i add a reference line that is an expression. I would like to include an average from a subset of data.

what about if i want to do something like this but in qlik?   ->

select s.session_id, avg(l.latency)

from sessionTable s, latencyTable l

where s.session_id = l.session_id

group by s.session_id