topic How to convert digital data information into a string upon loading in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-digital-data-information-into-a-string-upon/m-p/360477#M704287 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P></P><P>I have a data set which solely consists of 0 and 1. On loading, I want those numbers to be converted into string information: 0 = High and 1 = Low<BR />It should go into the following direction:</P><P></P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; DATA</P><P>&nbsp;&nbsp;&nbsp;&nbsp; if ( DATA = 0, "High", DATA) OR if( DATA= 1, "Low", DATA) as NewDATA</P><P></P><P>I would appreciate your help.</P><P></P><P>Martin</P><P></P><P><STRONG style="color: #0000ff; font-size: 8pt;"><STRONG style="color: #0000ff; font-size: 8pt;"><STRONG> </STRONG></STRONG></STRONG></P></BODY></HTML> Mon, 21 May 2012 08:36:44 GMT simondachstr 2012-05-21T08:36:44Z How to convert digital data information into a string upon loading https://community.qlik.com/t5/QlikView/How-to-convert-digital-data-information-into-a-string-upon/m-p/360477#M704287 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P></P><P>I have a data set which solely consists of 0 and 1. On loading, I want those numbers to be converted into string information: 0 = High and 1 = Low<BR />It should go into the following direction:</P><P></P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; DATA</P><P>&nbsp;&nbsp;&nbsp;&nbsp; if ( DATA = 0, "High", DATA) OR if( DATA= 1, "Low", DATA) as NewDATA</P><P></P><P>I would appreciate your help.</P><P></P><P>Martin</P><P></P><P><STRONG style="color: #0000ff; font-size: 8pt;"><STRONG style="color: #0000ff; font-size: 8pt;"><STRONG> </STRONG></STRONG></STRONG></P></BODY></HTML> Mon, 21 May 2012 08:36:44 GMT https://community.qlik.com/t5/QlikView/How-to-convert-digital-data-information-into-a-string-upon/m-p/360477#M704287 simondachstr 2012-05-21T08:36:44Z How to convert digital data information into a string upon loading https://community.qlik.com/t5/QlikView/How-to-convert-digital-data-information-into-a-string-upon/m-p/360478#M704288 <HTML><HEAD></HEAD><BODY><P> Hi</P><P></P><P>use the following:</P><P></P><P>If(DATA = 0, 'High', 'Low') As NewDATA</P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Mon, 21 May 2012 08:50:44 GMT https://community.qlik.com/t5/QlikView/How-to-convert-digital-data-information-into-a-string-upon/m-p/360478#M704288 jonathandienst 2012-05-21T08:50:44Z