topic Re: Calculated average of in expression in QlikView

Calculated average of in expression

Anonymous — Tue, 17 Jun 2014 20:07:21 GMT

Hi guys,

I'd like to calculate average of string variable.

I have the variable: Less, the same and More

I'd like to recode them to -1, 0 and 1 in expression

Is it possible to do it in the expression

Avg(IF(DDD='Less', -1, IF(DDD='the same', 0, IF(DDD='More', 1))) DDD)

Cheers,

eduardo_sommer — Tue, 17 Jun 2014 20:12:10 GMT

Try

Avg(Match(DDD, 'Less', 'the same', 'More)-2)

Eduardo

eduardo_sommer — Tue, 17 Jun 2014 20:13:55 GMT

If this doesn't work, do the conversion in the load script.

Eduardo

Anonymous — Tue, 17 Jun 2014 20:22:13 GMT

avg(pick(match(DDD,'Less','Same amount','More'),-1,0,1))

It works

Thanks.