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

[#1]

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?

[swuehl]

Maybe like

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

[awhitfield]

Hi Wei Chong,

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

Andy

[#4]

Hi,

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

[#5]

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

[#6]

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

[#7]

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