topic Text in chart avg value in QlikView

Text in chart avg value

Thu, 11 Dec 2014 15:15:23 GMT

Hello,

I have an average line for a chart and would like to show the value as 'Text in chart' in the presentation tab. For some reason though, i am generating an error with this syntax.

=Avg(Sum({$<Measure={1}, ProductId = {1}, Month = {1}>}Qty))

I do not want to use the 'y=' show eqution to display the value. Is there any other way of doing this??

Thank You

Re: Text in chart avg value

yduval75 — Thu, 11 Dec 2014 15:17:01 GMT

You have to use :

Avg({$<Measure={1}, ProductId = {1}, Month = {1}>}Qty)

Sum({$<Measure={1}, ProductId = {1}, Month = {1}>}Qty)

Count({$<Measure={1}, ProductId = {1}, Month = {1}>} DISTINCT ID)

Re: Text in chart avg value

Michiel_QV_Fan — Thu, 11 Dec 2014 15:18:42 GMT

replace sum with avg in your expression

avg({$<Measure={1}, ProductId = {1}, Month = {1}>}Qty)

Re: Text in chart avg value

Thu, 11 Dec 2014 15:25:42 GMT

So bc my expression was: Sum({$<Measure={1}, ProductId = {1}, Month = {1}>}Qty),

Avg({$<Measure={1}, ProductId = {1}, Month = {1}>}Qty) rendered a very small value that was wrong.

So, I wound up going with this:

Sum({$<Measure={1}, ProductId = {1}, Month = {1}>}Qty)

Count({$<Measure={1}, ProductId = {1}, Month = {1}>} DISTINCT ID)

Thank you both