Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Transform Text into Value

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

1 Reply
sunny_talwar

May be like this

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