Transform Text into Value

[#1]

Hi all,

I just started working on QlikView and I need your help

I have a string variable called Ad relevance wich has 4 types of values:

• Above average
• Average
• Below average
• --

I would like to transform the first 3 values in numbers like:

• Above average = 1
• Average = 0
• Below average = -1

In these way I can aggregate the ad relevance of all the ads of a campaign in a total average.

Should I use mapping to transform text into value? Or do you have any other suggestion about the general process, maybe there is a quicker way to have the same result?

Thanks,

Marta

[sunny_talwar]

May be like this

RangeSum(Match([Ad relevance], 'Below average', 'Average', 'Above average'), -2) as Numeric_Ad_Relevance