topic field values in QlikView https://community.qlik.com/t5/QlikView/field-values/m-p/854551#M992319 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; i have feild which contains the name of the plant. In that i want to remove 2 values and the same time i want to use that expresion in set to remove the count.</P><TABLE border="1" class="jiveBorder" height="124" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="border: 1px solid #000000; width: 122px; height: 97px;"><TBODY><TR><TD style="padding: 2px;"><P>plant</P><P>A</P><P>B</P><P>C</P><P>D</P></TD><TD style="padding: 2px;"><P>SUM</P><P>100</P><P>200</P><P>300</P><P>400</P></TD></TR></TBODY></TABLE><P></P><P>I want to remove B and C along with sum in an expression. In that expression i am already using set analysis</P><P>Regards,</P><P>rasool</P></BODY></HTML> Sat, 11 Jul 2015 11:31:47 GMT 2015-07-11T11:31:47Z field values https://community.qlik.com/t5/QlikView/field-values/m-p/854551#M992319 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; i have feild which contains the name of the plant. In that i want to remove 2 values and the same time i want to use that expresion in set to remove the count.</P><TABLE border="1" class="jiveBorder" height="124" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="border: 1px solid #000000; width: 122px; height: 97px;"><TBODY><TR><TD style="padding: 2px;"><P>plant</P><P>A</P><P>B</P><P>C</P><P>D</P></TD><TD style="padding: 2px;"><P>SUM</P><P>100</P><P>200</P><P>300</P><P>400</P></TD></TR></TBODY></TABLE><P></P><P>I want to remove B and C along with sum in an expression. In that expression i am already using set analysis</P><P>Regards,</P><P>rasool</P></BODY></HTML> Sat, 11 Jul 2015 11:31:47 GMT https://community.qlik.com/t5/QlikView/field-values/m-p/854551#M992319 2015-07-11T11:31:47Z Re: field values https://community.qlik.com/t5/QlikView/field-values/m-p/854552#M992320 <HTML><HEAD></HEAD><BODY><P>Would be easier if you post your current dimension and expression(s) used.</P><P></P><P>You can start with something like dimension plant and expression</P><P>=Sum({&lt;plant -= {B,C}&gt;} SUM)</P></BODY></HTML> Sat, 11 Jul 2015 11:36:50 GMT https://community.qlik.com/t5/QlikView/field-values/m-p/854552#M992320 swuehl 2015-07-11T11:36:50Z