topic Transform Text into Value in QlikView https://community.qlik.com/t5/QlikView/Transform-Text-into-Value/m-p/1402560#M424990 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I just started working on QlikView and I need your help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>I have a string variable called Ad relevance wich has 4 types of values:</P><UL><LI>Above average</LI><LI>Average</LI><LI>Below average</LI><LI>--</LI></UL><P></P><P>I would like to transform the first 3 values in numbers like:</P><UL><LI>Above average = 1</LI><LI>Average = 0</LI><LI>Below average = -1</LI></UL><P></P><P>In these way I can aggregate the ad relevance of all the ads of a campaign in a total average.</P><P>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?</P><P></P><P>Thanks,</P><P>Marta</P></BODY></HTML> Fri, 20 Oct 2017 09:51:14 GMT 2017-10-20T09:51:14Z Transform Text into Value https://community.qlik.com/t5/QlikView/Transform-Text-into-Value/m-p/1402560#M424990 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I just started working on QlikView and I need your help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>I have a string variable called Ad relevance wich has 4 types of values:</P><UL><LI>Above average</LI><LI>Average</LI><LI>Below average</LI><LI>--</LI></UL><P></P><P>I would like to transform the first 3 values in numbers like:</P><UL><LI>Above average = 1</LI><LI>Average = 0</LI><LI>Below average = -1</LI></UL><P></P><P>In these way I can aggregate the ad relevance of all the ads of a campaign in a total average.</P><P>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?</P><P></P><P>Thanks,</P><P>Marta</P></BODY></HTML> Fri, 20 Oct 2017 09:51:14 GMT https://community.qlik.com/t5/QlikView/Transform-Text-into-Value/m-p/1402560#M424990 2017-10-20T09:51:14Z Re: Transform Text into Value https://community.qlik.com/t5/QlikView/Transform-Text-into-Value/m-p/1402561#M424991 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><STRONG>RangeSum(Match([Ad relevance], '</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Below average', '</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Average', '</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Above average'), -2) as Numeric_Ad_Relevance</STRONG></SPAN></SPAN></SPAN></P></BODY></HTML> Fri, 20 Oct 2017 11:37:56 GMT https://community.qlik.com/t5/QlikView/Transform-Text-into-Value/m-p/1402561#M424991 sunny_talwar 2017-10-20T11:37:56Z