topic Re: Replace a Field Value in QlikView https://community.qlik.com/t5/QlikView/Replace-a-Field-Value/m-p/542360#M202693 <HTML><HEAD></HEAD><BODY><P>See attached example for one option.</P></BODY></HTML> Thu, 04 Jul 2013 17:02:18 GMT Gysbert_Wassenaar 2013-07-04T17:02:18Z Replace a Field Value https://community.qlik.com/t5/QlikView/Replace-a-Field-Value/m-p/542359#M202692 <HTML><HEAD></HEAD><BODY><P>I am looking to create a field where if the field MARKET_PRICE has a value of 0 for Hospital2 through Hospital7, it replace the 0 value for that MARKET_SERVICE with the MARKET_PRICE of Hospital1.&nbsp; I know I can get the result I am looking for by creating a new table and loading the data for the Hospital and LEFT JOINING back to my table.&nbsp; But I wanted to find out of there is a formula I can use in my script to pull in the value without doing a second load of the data. I have attached an Excel sample of the data and the result I am looking for.</P><P></P><P>Thanks</P><P></P><P>Brian </P></BODY></HTML> Thu, 04 Jul 2013 16:49:51 GMT https://community.qlik.com/t5/QlikView/Replace-a-Field-Value/m-p/542359#M202692 2013-07-04T16:49:51Z Re: Replace a Field Value https://community.qlik.com/t5/QlikView/Replace-a-Field-Value/m-p/542360#M202693 <HTML><HEAD></HEAD><BODY><P>See attached example for one option.</P></BODY></HTML> Thu, 04 Jul 2013 17:02:18 GMT https://community.qlik.com/t5/QlikView/Replace-a-Field-Value/m-p/542360#M202693 Gysbert_Wassenaar 2013-07-04T17:02:18Z