topic Replace '1' with '-' Without Replacing All 1's Occurring in Every Number in QlikView https://community.qlik.com/t5/QlikView/Replace-1-with-Without-Replacing-All-1-s-Occurring-in-Every/m-p/85131#M770613 <HTML><HEAD></HEAD><BODY><P>I just want to replace everything with a 'VIO' of 1 with a dash instead.</P><P></P><P>When I do this with PurgChar, it takes every 1 that occurs in every other number (such as 14) and changes it to -4, 2- etc. </P><P></P><P>I just want this to affect the numbers that are actually 1, and keep numbers like 21 and 100 the same if that makes any sense. </P><P></P><P>Thank you !</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/203397_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT oliveton 2020-11-25T16:16:04Z Replace '1' with '-' Without Replacing All 1's Occurring in Every Number https://community.qlik.com/t5/QlikView/Replace-1-with-Without-Replacing-All-1-s-Occurring-in-Every/m-p/85131#M770613 <HTML><HEAD></HEAD><BODY><P>I just want to replace everything with a 'VIO' of 1 with a dash instead.</P><P></P><P>When I do this with PurgChar, it takes every 1 that occurs in every other number (such as 14) and changes it to -4, 2- etc. </P><P></P><P>I just want this to affect the numbers that are actually 1, and keep numbers like 21 and 100 the same if that makes any sense. </P><P></P><P>Thank you !</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/203397_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Replace-1-with-Without-Replacing-All-1-s-Occurring-in-Every/m-p/85131#M770613 oliveton 2020-11-25T16:16:04Z Re: Replace '1' with '-' Without Replacing All 1's Occurring in Every Number https://community.qlik.com/t5/QlikView/Replace-1-with-Without-Replacing-All-1-s-Occurring-in-Every/m-p/85132#M770614 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Where</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Index</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="color: #800000; font-size: 9.0pt; font-family: 'Courier New';">20184</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">,'1')=1&nbsp; ?</SPAN></P></BODY></HTML> Thu, 24 May 2018 16:03:14 GMT https://community.qlik.com/t5/QlikView/Replace-1-with-Without-Replacing-All-1-s-Occurring-in-Every/m-p/85132#M770614 Anonymous 2018-05-24T16:03:14Z Re: Replace '1' with '-' Without Replacing All 1's Occurring in Every Number https://community.qlik.com/t5/QlikView/Replace-1-with-Without-Replacing-All-1-s-Occurring-in-Every/m-p/85133#M770615 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10.0pt; font-family: 'Helvetica',sans-serif; color: red;">pick(match(20184,'1'),'-') </SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Helvetica',sans-serif; color: red;"><BR /></SPAN></P><P><SPAN style="color: red; font-size: 10.0pt; font-family: 'Helvetica',sans-serif;">&nbsp; </SPAN></P></BODY></HTML> Thu, 24 May 2018 16:05:16 GMT https://community.qlik.com/t5/QlikView/Replace-1-with-Without-Replacing-All-1-s-Occurring-in-Every/m-p/85133#M770615 Anonymous 2018-05-24T16:05:16Z Re: Replace '1' with '-' Without Replacing All 1's Occurring in Every Number https://community.qlik.com/t5/QlikView/Replace-1-with-Without-Replacing-All-1-s-Occurring-in-Every/m-p/85134#M770616 <HTML><HEAD></HEAD><BODY><P>If([201804]='1','-',[201804]) as VIO</P></BODY></HTML> Thu, 24 May 2018 16:08:52 GMT https://community.qlik.com/t5/QlikView/Replace-1-with-Without-Replacing-All-1-s-Occurring-in-Every/m-p/85134#M770616 Gysbert_Wassenaar 2018-05-24T16:08:52Z Re: Replace '1' with '-' Without Replacing All 1's Occurring in Every Number https://community.qlik.com/t5/QlikView/Replace-1-with-Without-Replacing-All-1-s-Occurring-in-Every/m-p/85135#M770617 <HTML><HEAD></HEAD><BODY><P>Perfect, thank you!! </P></BODY></HTML> Thu, 24 May 2018 17:19:18 GMT https://community.qlik.com/t5/QlikView/Replace-1-with-Without-Replacing-All-1-s-Occurring-in-Every/m-p/85135#M770617 oliveton 2018-05-24T17:19:18Z