topic Re: Replace Old ones? in QlikView https://community.qlik.com/t5/QlikView/Replace-Old-ones/m-p/766639#M272379 <HTML><HEAD></HEAD><BODY><P>Do you mean text should be 'Null' in case of Null values in SupplierName?</P><P></P><P>If(Flag='Y',SupplierName,'Null')</P></BODY></HTML> Mon, 22 Dec 2014 07:55:59 GMT anbu1984 2014-12-22T07:55:59Z Replace Old ones? https://community.qlik.com/t5/QlikView/Replace-Old-ones/m-p/766634#M272374 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am having Some Product code and Supplier names...</P><P>If I am Selecting in the Product Code, I am getting the Relevant Supplier name...</P><P>But for Some of my Product codes Some New Suppliers are added, Where ever Product code we have added new Supplier name it was not Showing in the Report...</P><P></P><P>Because if I am Selecting Product code , Then 2 Supplier Names are Showing(Old Name &amp; New Name), because of ambiguity it was not showing in the Report, I Need to get the New Supplier Name in the Report...</P><P></P><P>How to to acheive this...</P><P></P><P>Help required...</P><P></P><P>Regards,</P><P>Heather</P></BODY></HTML> Fri, 19 Dec 2014 12:40:38 GMT https://community.qlik.com/t5/QlikView/Replace-Old-ones/m-p/766634#M272374 2014-12-19T12:40:38Z Re: Replace Old ones? https://community.qlik.com/t5/QlikView/Replace-Old-ones/m-p/766635#M272375 <HTML><HEAD></HEAD><BODY><P>If you have any date field, then you can use Firstsortedvalue() to retrieve latest supplier name</P><P></P><P>Firstsortedvalue(SupplierName,-Date)</P></BODY></HTML> Fri, 19 Dec 2014 13:21:57 GMT https://community.qlik.com/t5/QlikView/Replace-Old-ones/m-p/766635#M272375 anbu1984 2014-12-19T13:21:57Z Re: Replace Old ones? https://community.qlik.com/t5/QlikView/Replace-Old-ones/m-p/766636#M272376 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please can you post the expression you are using,if any.</P><P>so can help.</P><P></P><P>If possible post the sample data.</P><P></P><P>Regards</P><P>Neetha</P></BODY></HTML> Fri, 19 Dec 2014 13:41:58 GMT https://community.qlik.com/t5/QlikView/Replace-Old-ones/m-p/766636#M272376 Anonymous 2014-12-19T13:41:58Z Re: Replace Old ones? https://community.qlik.com/t5/QlikView/Replace-Old-ones/m-p/766637#M272377 <HTML><HEAD></HEAD><BODY><P>HI anbu,</P><P></P><P>I have One Flag, If i am using that flag condition "Y" i am getting Correct Supplier Names, but the thing was for Some Product code there is no Supplier name Default, but I need to Show them with NUll Value only as Previously...</P><P></P><P>Regards,</P><P>Heather</P></BODY></HTML> Mon, 22 Dec 2014 06:39:06 GMT https://community.qlik.com/t5/QlikView/Replace-Old-ones/m-p/766637#M272377 2014-12-22T06:39:06Z Re: Replace Old ones? https://community.qlik.com/t5/QlikView/Replace-Old-ones/m-p/766638#M272378 <HTML><HEAD></HEAD><BODY><P>HI Neetha,</P><P></P><P>I am Simply Pulling the Field into Expression,</P><P>Because of Some Product code Names Supplier name has changed to a New One..</P><P>So in Report. I am not getting Supplier names because I am having One more New Supplier Name..</P><P>I need to get the Latest Supplier name, if i am not having any Supplier Names for any Specific Code it Should Show Blank..</P><P></P><P>Regards,</P><P>Heather</P></BODY></HTML> Mon, 22 Dec 2014 07:24:49 GMT https://community.qlik.com/t5/QlikView/Replace-Old-ones/m-p/766638#M272378 2014-12-22T07:24:49Z Re: Replace Old ones? https://community.qlik.com/t5/QlikView/Replace-Old-ones/m-p/766639#M272379 <HTML><HEAD></HEAD><BODY><P>Do you mean text should be 'Null' in case of Null values in SupplierName?</P><P></P><P>If(Flag='Y',SupplierName,'Null')</P></BODY></HTML> Mon, 22 Dec 2014 07:55:59 GMT https://community.qlik.com/t5/QlikView/Replace-Old-ones/m-p/766639#M272379 anbu1984 2014-12-22T07:55:59Z Re: Replace Old ones? https://community.qlik.com/t5/QlikView/Replace-Old-ones/m-p/766640#M272380 <HTML><HEAD></HEAD><BODY><P>May be try in script:</P><P></P><P>If((Len(Trim(SupplierName))='0','Null',SupplierName) as SupplierName</P></BODY></HTML> Mon, 22 Dec 2014 09:31:22 GMT https://community.qlik.com/t5/QlikView/Replace-Old-ones/m-p/766640#M272380 Anonymous 2014-12-22T09:31:22Z