topic Re: Changing Expressions to filter out values from calculation in QlikView https://community.qlik.com/t5/QlikView/Changing-Expressions-to-filter-out-values-from-calculation/m-p/1249893#M461935 <HTML><HEAD></HEAD><BODY><P>If you mean eliminating rows with pallet = P:</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;">sum({&lt;pallet-={'P'}&gt;} Amount)</SPAN></P><P></P><P>If you mean eliminating any style for which any row of that style has pallet = P, I think this?</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;">sum({&lt;style*=P({1&lt;pallet-={'P'}&gt;})&gt;} Amount)</SPAN></P><P></P><P>Not that these are your expressions. Your expressions seem much more complicated in some cases, but it's the set expression that's important. In some cases there's no aggregation function at all. If you need the logic, use an only() expression around those expressions to add the set analysis.</P></BODY></HTML> Mon, 14 Nov 2016 23:06:23 GMT johnw 2016-11-14T23:06:23Z Changing Expressions to filter out values from calculation https://community.qlik.com/t5/QlikView/Changing-Expressions-to-filter-out-values-from-calculation/m-p/1249892#M461934 <HTML><HEAD></HEAD><BODY><P>HI there,</P><P></P><P>I need some help with making a modification to a sales report.</P><P></P><P>I need to change my expressions to remove any style with pallet=p from the calculation.</P><P></P><P>How do I this properly?</P><P></P><P>Thanks in advance.</P></BODY></HTML> Mon, 14 Nov 2016 21:49:29 GMT https://community.qlik.com/t5/QlikView/Changing-Expressions-to-filter-out-values-from-calculation/m-p/1249892#M461934 ccb-it2013 2016-11-14T21:49:29Z Re: Changing Expressions to filter out values from calculation https://community.qlik.com/t5/QlikView/Changing-Expressions-to-filter-out-values-from-calculation/m-p/1249893#M461935 <HTML><HEAD></HEAD><BODY><P>If you mean eliminating rows with pallet = P:</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;">sum({&lt;pallet-={'P'}&gt;} Amount)</SPAN></P><P></P><P>If you mean eliminating any style for which any row of that style has pallet = P, I think this?</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;">sum({&lt;style*=P({1&lt;pallet-={'P'}&gt;})&gt;} Amount)</SPAN></P><P></P><P>Not that these are your expressions. Your expressions seem much more complicated in some cases, but it's the set expression that's important. In some cases there's no aggregation function at all. If you need the logic, use an only() expression around those expressions to add the set analysis.</P></BODY></HTML> Mon, 14 Nov 2016 23:06:23 GMT https://community.qlik.com/t5/QlikView/Changing-Expressions-to-filter-out-values-from-calculation/m-p/1249893#M461935 johnw 2016-11-14T23:06:23Z