Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Maybe like
=Avg( {<Service = {'3G'} >} MeasureField)
Hi Wei Chong,
are you able to unload any example source data or a sample QVW?
Andy
Hi,
my apologies for not stating clearly. I am actually using qlik sense and not qlik view
OK I will try that and let you know if that works! Thank you!
Oh yes, any idea where can i find documentation on t?
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