topic Re: Expression for Average Trendlines ? in QlikView

Expression for Average Trendlines ?

Fri, 04 Dec 2015 20:08:34 GMT

Hi,

Currently,

We are using Average Trend lines provided by QV and

we are getting below blue Line as Average.

But, Now, we need to use expression instead of Average Trend Line provided by QV.

We are trying to show same thing - same average line but through Expression.

below is our expression for below blue lines.

=Avg({$<[Field] = {XX}>}[Sales])

can someone help us,

how we can achieve and build below average trend lines in blue through expression ?

sunny_talwar — Fri, 04 Dec 2015 20:11:14 GMT

Try this as your expression:

=Avg(TOTAL {$<[Field] = {XX}>}[Sales])

Fri, 04 Dec 2015 20:23:12 GMT

Thanks Sunny.

i had tried.

but, still, it shows sum of Sales for one selected product.

we need to compare sales of one product with average sales of all product.

average sales of all produce in one straight light which is average trend line.

sales of one product is in bar chart.

sunny_talwar — Fri, 04 Dec 2015 20:25:19 GMT

What about this:

=Avg(TOTAL {1<[Field] = {XX}>}[Sales])

this should disregard any selections

or this:

=Avg(TOTAL {$<[Field] = {XX}, Product>}[Sales])

Fri, 04 Dec 2015 20:29:49 GMT

Thanks Sunny.

how about Line ?

How to show that as one straight line shows in example ?

sunny_talwar — Fri, 04 Dec 2015 20:31:20 GMT

TOTAL qualifier should have gotten you a straight line. Would you be able to share few data points to test out?

Fri, 04 Dec 2015 21:15:31 GMT

Thank..

it appears to be working.