topic Re: change value with if statement in QlikView https://community.qlik.com/t5/QlikView/change-value-with-if-statement/m-p/581691#M682895 <HTML><HEAD></HEAD><BODY><P>Sorry, here are the 2 tables</P><TABLE border="0" cellpadding="0" cellspacing="0" width="278"><TBODY><TR><TD class="xl76" height="21" width="80">ITEMS</TD><TD class="xl75" width="80"> </TD><TD width="14"></TD><TD class="xl74" width="104">Pflichtartikeln</TD></TR><TR><TD class="xl72" height="21" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">ItemId</TD><TD class="xl73" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">pflicht</TD><TD></TD><TD class="xl67" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">ItemId</TD></TR><TR><TD class="xl68" height="20">CDR</TD><TD class="xl78">URA</TD><TD></TD><TD class="xl65">URA</TD></TR><TR><TD class="xl68" height="20">Tinte</TD><TD class="xl77">&lt;null&gt;</TD><TD></TD><TD class="xl65">URA-1</TD></TR><TR><TD class="xl68" height="21">Toner</TD><TD class="xl77">&lt;null&gt;</TD><TD></TD><TD class="xl66">URA-2</TD></TR><TR><TD class="xl68" height="20">USB-Stick</TD><TD class="xl78">URA-1</TD><TD></TD><TD></TD></TR><TR><TD class="xl68" height="20">Festplatte</TD><TD class="xl77">&lt;null&gt;</TD><TD></TD><TD></TD></TR><TR><TD class="xl68" height="20">PC</TD><TD class="xl77">&lt;null&gt;</TD><TD></TD><TD></TD></TR><TR><TD class="xl68" height="20">DVD</TD><TD class="xl78">URA</TD><TD></TD><TD></TD></TR><TR><TD class="xl68" height="20">URA</TD><TD class="xl69">&lt;null&gt;</TD><TD></TD><TD></TD></TR><TR><TD class="xl70" height="21">URA-1</TD><TD class="xl71">&lt;null&gt;</TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>how, can I attach a XLX Document?</P></BODY></HTML> Mon, 17 Mar 2014 10:25:57 GMT 2014-03-17T10:25:57Z change value with if statement https://community.qlik.com/t5/QlikView/change-value-with-if-statement/m-p/581690#M682894 <HTML><HEAD></HEAD><BODY><P>Hallo zusammen</P><P></P><P>Ich habe 2 Tabellen &lt;Items&gt; und &lt;Pflichtartikel&gt;</P><P><SPAN class="hps"></SPAN></P><P><SPAN class="hps">Wenn ich die Tabelle &lt;items&gt; lade, sollte verglichen werden, ob dieser Artikel (Itemid) in der Tabelle &lt;Pflichtartikel&gt;</SPAN></P><P><SPAN class="hps">vorkommt. Wenn ja, dann soll der Wert in der Spalte (pflicht) mit der ItemId geändert werden.</SPAN></P><P><SPAN class="hps"></SPAN></P><P><SPAN class="hps">Das Ergebnis meines EXCEL Sheet soll wie folgt ausschauen.</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:59:56 GMT https://community.qlik.com/t5/QlikView/change-value-with-if-statement/m-p/581690#M682894 2014-03-17T09:59:56Z Re: change value with if statement https://community.qlik.com/t5/QlikView/change-value-with-if-statement/m-p/581691#M682895 <HTML><HEAD></HEAD><BODY><P>Sorry, here are the 2 tables</P><TABLE border="0" cellpadding="0" cellspacing="0" width="278"><TBODY><TR><TD class="xl76" height="21" width="80">ITEMS</TD><TD class="xl75" width="80"> </TD><TD width="14"></TD><TD class="xl74" width="104">Pflichtartikeln</TD></TR><TR><TD class="xl72" height="21" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">ItemId</TD><TD class="xl73" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">pflicht</TD><TD></TD><TD class="xl67" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">ItemId</TD></TR><TR><TD class="xl68" height="20">CDR</TD><TD class="xl78">URA</TD><TD></TD><TD class="xl65">URA</TD></TR><TR><TD class="xl68" height="20">Tinte</TD><TD class="xl77">&lt;null&gt;</TD><TD></TD><TD class="xl65">URA-1</TD></TR><TR><TD class="xl68" height="21">Toner</TD><TD class="xl77">&lt;null&gt;</TD><TD></TD><TD class="xl66">URA-2</TD></TR><TR><TD class="xl68" height="20">USB-Stick</TD><TD class="xl78">URA-1</TD><TD></TD><TD></TD></TR><TR><TD class="xl68" height="20">Festplatte</TD><TD class="xl77">&lt;null&gt;</TD><TD></TD><TD></TD></TR><TR><TD class="xl68" height="20">PC</TD><TD class="xl77">&lt;null&gt;</TD><TD></TD><TD></TD></TR><TR><TD class="xl68" height="20">DVD</TD><TD class="xl78">URA</TD><TD></TD><TD></TD></TR><TR><TD class="xl68" height="20">URA</TD><TD class="xl69">&lt;null&gt;</TD><TD></TD><TD></TD></TR><TR><TD class="xl70" height="21">URA-1</TD><TD class="xl71">&lt;null&gt;</TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>how, can I attach a XLX Document?</P></BODY></HTML> Mon, 17 Mar 2014 10:25:57 GMT https://community.qlik.com/t5/QlikView/change-value-with-if-statement/m-p/581691#M682895 2014-03-17T10:25:57Z Re: change value with if statement https://community.qlik.com/t5/QlikView/change-value-with-if-statement/m-p/581692#M682896 <HTML><HEAD></HEAD><BODY><P>I solved the problem with "Concatenate"</P><P></P><P>Thanks to all</P><P></P></BODY></HTML> Mon, 17 Mar 2014 11:36:04 GMT https://community.qlik.com/t5/QlikView/change-value-with-if-statement/m-p/581692#M682896 2014-03-17T11:36:04Z