https://community.qlik.com/t5/QlikView/Replace-names-into-another-in-qlikview-script/m-p/1615205#M736325 <DIV class="js-vote-count grid--cell fc-black-500 fs-title grid fd-column ai-center">&nbsp;</DIV><DIV class="post-text"><P>Here i want to ask i have this line in qlivkiew script in that i want if there is "<STRONG>abc</STRONG>" or "<STRONG>def</STRONG>" available then i want to consider these as <STRONG>XYZ</STRONG> and if not available then want to consider as "<STRONG>NONE</STRONG>"</P><PRE>if(if(Filename = '1.xlsx','DR', if(Filename = '2.xlsx','DR', if(Filename = '3.xlsx','DRD', if(Filename = '4.xlsx', 'DRD', ApplyMap('Segm',Ext.,RGro') = 'abc' or 'def', 'XYZ','None') as In_Flag</PRE><P>how i modified this line according to my requirement</P><P>how i do that</P><P>any idea about this condition ?</P></DIV> Sat, 16 Nov 2024 02:40:27 GMT capriconuser 2024-11-16T02:40:27Z https://community.qlik.com/t5/QlikView/Replace-names-into-another-in-qlikview-script/m-p/1615205#M736325 <DIV class="js-vote-count grid--cell fc-black-500 fs-title grid fd-column ai-center">&nbsp;</DIV><DIV class="post-text"><P>Here i want to ask i have this line in qlivkiew script in that i want if there is "<STRONG>abc</STRONG>" or "<STRONG>def</STRONG>" available then i want to consider these as <STRONG>XYZ</STRONG> and if not available then want to consider as "<STRONG>NONE</STRONG>"</P><PRE>if(if(Filename = '1.xlsx','DR', if(Filename = '2.xlsx','DR', if(Filename = '3.xlsx','DRD', if(Filename = '4.xlsx', 'DRD', ApplyMap('Segm',Ext.,RGro') = 'abc' or 'def', 'XYZ','None') as In_Flag</PRE><P>how i modified this line according to my requirement</P><P>how i do that</P><P>any idea about this condition ?</P></DIV> Sat, 16 Nov 2024 02:40:27 GMT https://community.qlik.com/t5/QlikView/Replace-names-into-another-in-qlikview-script/m-p/1615205#M736325 capriconuser 2024-11-16T02:40:27Z https://community.qlik.com/t5/QlikView/Replace-names-into-another-in-qlikview-script/m-p/1615949#M736326 <P>May be this</P><PRE>If(Filename = '1.xlsx','DR',<BR />If(Filename = '2.xlsx','DR',<BR />If(Filename = '3.xlsx','DRD',<BR />If(Filename = '4.xlsx', 'DRD',<BR />If(ApplyMap('Segm',Ext.,RGro') = 'abc' or ApplyMap('Segm',Ext.,RGro') = 'def', 'XYZ', 'None') as In_Flag</PRE> Fri, 23 Aug 2019 12:17:03 GMT https://community.qlik.com/t5/QlikView/Replace-names-into-another-in-qlikview-script/m-p/1615949#M736326 sunny_talwar 2019-08-23T12:17:03Z