topic Re: change value with if statement in QlikView https://community.qlik.com/t5/QlikView/change-value-with-if-statement/m-p/581735#M682925 <HTML><HEAD></HEAD><BODY><P>What is your input tables?</P><P>On what basis you want to compare Itemids...?</P></BODY></HTML> Mon, 17 Mar 2014 09:59:19 GMT MK_QSL 2014-03-17T09:59:19Z change value with if statement https://community.qlik.com/t5/QlikView/change-value-with-if-statement/m-p/581734#M682924 <HTML><HEAD></HEAD><BODY><P><BR />Hello together,</P><P></P><P>I have 2 Tables &lt;Items&gt; and &lt;Pflichtartikel&gt;</P><P><SPAN class="hps"></SPAN></P><P><SPAN class="hps">When I load the</SPAN> <SPAN class="hps">table &lt;Items&gt; it should</SPAN><SPAN class="hps"> compare</SPAN>, if<SPAN class="hps"> the</SPAN> <SPAN class="hps">ITEMID</SPAN> <SPAN class="hps">exist in the table</SPAN> <SPAN class="hps">&lt;Pflichtartikel&gt;</SPAN>. </P><P><SPAN class="hps">If so, then</SPAN> the Value <SPAN class="hps">NULL</SPAN> should be changed to t<SPAN class="hps">he</SPAN> value of the <SPAN class="hps">ItemId</SPAN><SPAN class="hps">.</SPAN> </P><P><SPAN class="hps">The result should look like</SPAN></P><P><SPAN class="hps"></SPAN><SPAN class="hps"></SPAN> </P><P><SPAN class="hps">ItemId&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pflicht</SPAN></P><P><SPAN class="hps">CDR&nbsp;&nbsp;&nbsp; URA</SPAN></P><P><SPAN class="hps">Tinte&nbsp;&nbsp;&nbsp; &lt;null&gt;</SPAN></P><P><SPAN class="hps">Toner&nbsp; &lt;null&gt;</SPAN></P><P><SPAN class="hps">USB-Stick URA-1</SPAN></P><P><SPAN class="hps">Festplatte &lt;null&gt;</SPAN></P><P><SPAN class="hps">PC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;null&gt;</SPAN></P><P><SPAN class="hps">DVD&nbsp;&nbsp;&nbsp;&nbsp; URA</SPAN></P><P><SPAN class="hps">URA&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">URA</SPAN></SPAN></P><P>URA-1<SPAN style="color: #ff0000;"><SPAN class="hps">&nbsp; <SPAN style="color: #ff0000;">URA-1</SPAN></SPAN></SPAN></P><P></P><P>Thanks fo help</P><P>puwo</P></BODY></HTML> Mon, 17 Mar 2014 09:56:32 GMT https://community.qlik.com/t5/QlikView/change-value-with-if-statement/m-p/581734#M682924 2014-03-17T09:56:32Z Re: change value with if statement https://community.qlik.com/t5/QlikView/change-value-with-if-statement/m-p/581735#M682925 <HTML><HEAD></HEAD><BODY><P>What is your input tables?</P><P>On what basis you want to compare Itemids...?</P></BODY></HTML> Mon, 17 Mar 2014 09:59:19 GMT https://community.qlik.com/t5/QlikView/change-value-with-if-statement/m-p/581735#M682925 MK_QSL 2014-03-17T09:59:19Z Re: change value with if statement https://community.qlik.com/t5/QlikView/change-value-with-if-statement/m-p/581736#M682926 <HTML><HEAD></HEAD><BODY><P>Can you not just join in the script ?</P><P></P><P>ie - table1:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; load * from data 1</P><P>join</P><P>&nbsp;&nbsp;&nbsp;&nbsp; load * from data 2</P></BODY></HTML> Mon, 17 Mar 2014 10:38:47 GMT https://community.qlik.com/t5/QlikView/change-value-with-if-statement/m-p/581736#M682926 2014-03-17T10:38:47Z Re: change value with if statement https://community.qlik.com/t5/QlikView/change-value-with-if-statement/m-p/581737#M682927 <HTML><HEAD></HEAD><BODY><P>No, I can't. Because I have only to change the value "pflicht" if the ItemId is in the second table.</P><P>Thanks</P></BODY></HTML> Mon, 17 Mar 2014 10:47:22 GMT https://community.qlik.com/t5/QlikView/change-value-with-if-statement/m-p/581737#M682927 2014-03-17T10:47:22Z Re: change value with if statement https://community.qlik.com/t5/QlikView/change-value-with-if-statement/m-p/581738#M682928 <HTML><HEAD></HEAD><BODY><P>Pls check below link, will help in updating resident table values.</P><P></P><P><A href="http://www.qlikcommunity.com/thread/93969" title="http://www.qlikcommunity.com/thread/93969">Update Values in Resident table | Qlik Community</A></P></BODY></HTML> Mon, 17 Mar 2014 11:03:03 GMT https://community.qlik.com/t5/QlikView/change-value-with-if-statement/m-p/581738#M682928 manojkulkarni 2014-03-17T11:03:03Z