topic Re: set analysis in chart in QlikView

set analysis in chart

Mon, 16 Mar 2015 15:49:43 GMT

Hi,

I've a difficult situation which i want to solve in the expression and not in the script.

column A :contains calculation with average of 21.16

column B: what I want to get is the value in column A minus the high average

(average of the rows of A above the average - in this case the white rows)

Thanks in advance

'A' AVG: 21.16

High 'A' AVG: 31.09

MK_QSL — Mon, 16 Mar 2015 15:52:14 GMT

Kindly provide Sample Apps or Sample Data !

buzzy996 — Mon, 16 Mar 2015 16:49:26 GMT

can u try this,

create a variable = store ur max avg value in this field.

and in ur chart use field B = A - variable.

Anonymous — Mon, 16 Mar 2015 17:34:01 GMT

Expression is:

A - avg(total if(A>avg(total A), A))

maxgro — Mon, 16 Mar 2015 17:38:24 GMT

PFA