https://community.qlik.com/t5/QlikView/Conditional-Expression-in-Pivot-table/m-p/1523393#M748295 <P>Hi everybody</P><P>I have question that I hope you can help with</P><P>Below you can find an example of what I need .</P><P>I need the code for command&nbsp; " İf there is two different type for the same id use type "Yes" and "if there is only one type written use the written type"</P><P>Example:</P><P>ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Weight&nbsp; &nbsp; &nbsp;Data&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Weight*Data</P><P>---&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ---------&nbsp; &nbsp;&nbsp;<SPAN>---------&nbsp; &nbsp; &nbsp; &nbsp;------------------</SPAN></P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;No &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;120&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;120</P><P>1&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Yes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;120 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 610</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;210</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;No &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;80&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;272</P><P>4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 150&nbsp;</P><P>4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Yes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 81</P><P>&nbsp;</P><P>Expected result :</P><P>ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Weight&nbsp; &nbsp; &nbsp;Data&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Weight*Data</P><P>---&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ---------&nbsp; &nbsp;&nbsp;<SPAN>---------&nbsp; &nbsp; &nbsp; &nbsp;------------------</SPAN></P><P><SPAN>1&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>&nbsp;</SPAN><SPAN>Yes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;120</SPAN><SPAN>&nbsp;</SPAN><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 610</SPAN></P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;210</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;No &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;80&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;272</P><P>4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Yes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 81</P><P>Thanks&nbsp;</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT mhamurcuoglu 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Conditional-Expression-in-Pivot-table/m-p/1523393#M748295 <P>Hi everybody</P><P>I have question that I hope you can help with</P><P>Below you can find an example of what I need .</P><P>I need the code for command&nbsp; " İf there is two different type for the same id use type "Yes" and "if there is only one type written use the written type"</P><P>Example:</P><P>ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Weight&nbsp; &nbsp; &nbsp;Data&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Weight*Data</P><P>---&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ---------&nbsp; &nbsp;&nbsp;<SPAN>---------&nbsp; &nbsp; &nbsp; &nbsp;------------------</SPAN></P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;No &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;120&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;120</P><P>1&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Yes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;120 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 610</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;210</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;No &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;80&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;272</P><P>4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 150&nbsp;</P><P>4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Yes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 81</P><P>&nbsp;</P><P>Expected result :</P><P>ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Weight&nbsp; &nbsp; &nbsp;Data&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Weight*Data</P><P>---&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ---------&nbsp; &nbsp;&nbsp;<SPAN>---------&nbsp; &nbsp; &nbsp; &nbsp;------------------</SPAN></P><P><SPAN>1&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>&nbsp;</SPAN><SPAN>Yes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;120</SPAN><SPAN>&nbsp;</SPAN><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 610</SPAN></P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;210</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;No &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;80&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;272</P><P>4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Yes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 81</P><P>Thanks&nbsp;</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Conditional-Expression-in-Pivot-table/m-p/1523393#M748295 mhamurcuoglu 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Conditional-Expression-in-Pivot-table/m-p/1523407#M748297 <P>See attached qvw</P> Fri, 21 Dec 2018 11:13:17 GMT https://community.qlik.com/t5/QlikView/Conditional-Expression-in-Pivot-table/m-p/1523407#M748297 Gysbert_Wassenaar 2018-12-21T11:13:17Z https://community.qlik.com/t5/QlikView/Conditional-Expression-in-Pivot-table/m-p/1523414#M748298 <P><SPAN class="UserName lia-user-name lia-user-rank-MVP lia-component-message-view-widget-author-username"><SPAN class="login-bold">Thank you for your help&nbsp;</SPAN></SPAN></P><P>&nbsp;</P><DIV class="lia-message-author-rank lia-component-author-rank"><SPAN>&nbsp;</SPAN></DIV> Fri, 21 Dec 2018 11:51:41 GMT https://community.qlik.com/t5/QlikView/Conditional-Expression-in-Pivot-table/m-p/1523414#M748298 mhamurcuoglu 2018-12-21T11:51:41Z