topic Formating a string value in QlikView https://community.qlik.com/t5/QlikView/Formating-a-string-value/m-p/241005#M91456 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>In edit script you can solve this problem during loading as..</P><P></P><P>Load</P><P>upper(Field1) as Field1,</P><P>....</P><P>...</P><P>.</P><P>This fetch you all your to Upper case.. which will solve your problem..</P></BODY></HTML> Thu, 18 Feb 2010 05:41:06 GMT achiever_ajay 2010-02-18T05:41:06Z Formating a string value https://community.qlik.com/t5/QlikView/Formating-a-string-value/m-p/241004#M91455 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Can anyone help me out in this,</P><P>I have one column, which has values like</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 101pt; border-collapse: collapse;" width="135"><COLGROUP><COL style="width: 101pt; mso-width-source: userset; mso-width-alt: 4937;" width="135" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl24" height="17" style="width: 101pt; height: 12.75pt; background-color: transparent; border: windowtext 0.5pt solid;" width="135"><STRONG>Program</STRONG></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl25" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: white;" str="Application Manager ">Application Manager</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl25" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: white;" str="Applications ">Applications</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl26" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">DFS200x</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl26" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">Accounts</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl26" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">ACCOUNTS</TD></TR></TBODY></TABLE><BR /><BR /> <P>Here the Accounts and ACCOUNTS both are same, but due to the upper and lower case, qlik view considering as different and it shows as two different Program, I need to solve this.</P><P>Other values are correct,</P><P>Thanks in Advance,</P><P>Dhoulath</P></BODY></HTML> Thu, 18 Feb 2010 05:01:12 GMT https://community.qlik.com/t5/QlikView/Formating-a-string-value/m-p/241004#M91455 2010-02-18T05:01:12Z Formating a string value https://community.qlik.com/t5/QlikView/Formating-a-string-value/m-p/241005#M91456 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>In edit script you can solve this problem during loading as..</P><P></P><P>Load</P><P>upper(Field1) as Field1,</P><P>....</P><P>...</P><P>.</P><P>This fetch you all your to Upper case.. which will solve your problem..</P></BODY></HTML> Thu, 18 Feb 2010 05:41:06 GMT https://community.qlik.com/t5/QlikView/Formating-a-string-value/m-p/241005#M91456 achiever_ajay 2010-02-18T05:41:06Z