topic Sum two filters or more in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Sum-two-filters-or-more/m-p/15338#M145 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>In KPI I am trying to sum two or more filters which are in same column. </P><P></P><P>Sum({$&lt;[ product type]={"FIX"}&gt;} and {$&lt;[ product type]={"FIX"}&gt;}[Count Shipment]) [<SPAN style="color: #ff0000;">this gives an error]</SPAN></P><P><SPAN style="color: #ff0000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Sum({$&lt;[product type]={"FIX"},[product type]={"TIME_WINDOW"}&gt;}[Count Shipment]) [<SPAN style="color: #ff0000;">this only reads the last one (TIME_WINDOW)<SPAN style="color: #000000;">]</SPAN></SPAN></SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Can you please help me with this.</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Thank you &amp; Regards,</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Sachin</SPAN></P></BODY></HTML> Tue, 13 Feb 2018 11:20:31 GMT Anonymous 2018-02-13T11:20:31Z Sum two filters or more https://community.qlik.com/t5/Connectivity-Data-Prep/Sum-two-filters-or-more/m-p/15338#M145 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>In KPI I am trying to sum two or more filters which are in same column. </P><P></P><P>Sum({$&lt;[ product type]={"FIX"}&gt;} and {$&lt;[ product type]={"FIX"}&gt;}[Count Shipment]) [<SPAN style="color: #ff0000;">this gives an error]</SPAN></P><P><SPAN style="color: #ff0000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Sum({$&lt;[product type]={"FIX"},[product type]={"TIME_WINDOW"}&gt;}[Count Shipment]) [<SPAN style="color: #ff0000;">this only reads the last one (TIME_WINDOW)<SPAN style="color: #000000;">]</SPAN></SPAN></SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Can you please help me with this.</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Thank you &amp; Regards,</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Sachin</SPAN></P></BODY></HTML> Tue, 13 Feb 2018 11:20:31 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Sum-two-filters-or-more/m-p/15338#M145 Anonymous 2018-02-13T11:20:31Z Re: Sum two filters or more https://community.qlik.com/t5/Connectivity-Data-Prep/Sum-two-filters-or-more/m-p/15339#M146 <HTML><HEAD></HEAD><BODY><P>Try Sum({$&lt;[product type]={'FIX','TIME_WINDOW'}&gt;} [Count Shipment])</P></BODY></HTML> Tue, 13 Feb 2018 12:17:57 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Sum-two-filters-or-more/m-p/15339#M146 jwjackso 2018-02-13T12:17:57Z