topic Re: Alias for values in Column in QlikView https://community.qlik.com/t5/QlikView/Alias-for-values-in-Column/m-p/1137683#M904110 <HTML><HEAD></HEAD><BODY><P>Try: left([<STRONG>Key Individual</STRONG>], 1) &amp; '-' &amp; subfield([<STRONG>Key Individual</STRONG>], '-', 2)</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 29 Jun 2016 15:14:54 GMT marcus_sommer 2016-06-29T15:14:54Z Alias for values in Column https://community.qlik.com/t5/QlikView/Alias-for-values-in-Column/m-p/1137682#M904109 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a requirement like i want to do alias for values in a particular Column and my source is Excel sheet</P><P>say for example</P><P></P><P>Column Name is <STRONG>Key Individual</STRONG> and the values are<STRONG> Hospital-KI</STRONG> and<STRONG> IDN -KI</STRONG> . Now i want to do alias these values like H-KI and I-KI in this Column at <STRONG>Script level.</STRONG></P><P></P><P>How to achieve this</P><P></P><P></P><P>Thanks in Advance</P><P>Reddi Kishor</P><P></P><P>Happy Viewing <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Alias-for-values-in-Column/m-p/1137682#M904109 2020-11-25T16:16:04Z Re: Alias for values in Column https://community.qlik.com/t5/QlikView/Alias-for-values-in-Column/m-p/1137683#M904110 <HTML><HEAD></HEAD><BODY><P>Try: left([<STRONG>Key Individual</STRONG>], 1) &amp; '-' &amp; subfield([<STRONG>Key Individual</STRONG>], '-', 2)</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 29 Jun 2016 15:14:54 GMT https://community.qlik.com/t5/QlikView/Alias-for-values-in-Column/m-p/1137683#M904110 marcus_sommer 2016-06-29T15:14:54Z