topic Re: Keeping a sum when a filter is selected in QlikView https://community.qlik.com/t5/QlikView/Keeping-a-sum-when-a-filter-is-selected/m-p/1047846#M466676 <HTML><HEAD></HEAD><BODY><P>You can disregard selections in specific fields using set analysis, like</P><P></P><P>=Sum(<STRONG>{&lt;Transfer= &gt;}</STRONG> Cost)</P><P></P><P>to clear selections in field Transfer when summing Cost field.</P></BODY></HTML> Thu, 21 Jan 2016 18:51:55 GMT swuehl 2016-01-21T18:51:55Z Keeping a sum when a filter is selected https://community.qlik.com/t5/QlikView/Keeping-a-sum-when-a-filter-is-selected/m-p/1047845#M466675 <HTML><HEAD></HEAD><BODY><P>I have a sum of cost for states but when I select a filter, the sum of the state decreases. I was wondering how I can keep the cost for the state regardless of the filter. Below is a snapshot of it. </P><P></P><P></P><P>Before Filter: </P><P><IMG alt="Before Filter.PNG" class="jive-image image-1" src="/legacyfs/online/112247_Before Filter.PNG" style="height: 136px; width: 620px;" /></P><P></P><P>After Filter:</P><P><IMG alt="After Filter.PNG" class="jive-image image-2" src="/legacyfs/online/112248_After Filter.PNG" style="height: 135px; width: 620px;" /></P></BODY></HTML> Thu, 21 Jan 2016 17:49:34 GMT https://community.qlik.com/t5/QlikView/Keeping-a-sum-when-a-filter-is-selected/m-p/1047845#M466675 2016-01-21T17:49:34Z Re: Keeping a sum when a filter is selected https://community.qlik.com/t5/QlikView/Keeping-a-sum-when-a-filter-is-selected/m-p/1047846#M466676 <HTML><HEAD></HEAD><BODY><P>You can disregard selections in specific fields using set analysis, like</P><P></P><P>=Sum(<STRONG>{&lt;Transfer= &gt;}</STRONG> Cost)</P><P></P><P>to clear selections in field Transfer when summing Cost field.</P></BODY></HTML> Thu, 21 Jan 2016 18:51:55 GMT https://community.qlik.com/t5/QlikView/Keeping-a-sum-when-a-filter-is-selected/m-p/1047846#M466676 swuehl 2016-01-21T18:51:55Z Re: Keeping a sum when a filter is selected https://community.qlik.com/t5/QlikView/Keeping-a-sum-when-a-filter-is-selected/m-p/1047847#M466677 <HTML><HEAD></HEAD><BODY><P>Awesome. It works. Thanks Swuehl!!!</P></BODY></HTML> Fri, 22 Jan 2016 17:02:08 GMT https://community.qlik.com/t5/QlikView/Keeping-a-sum-when-a-filter-is-selected/m-p/1047847#M466677 2016-01-22T17:02:08Z