topic How can I seperate filtered sum value and overall sum value? in App Development https://community.qlik.com/t5/App-Development/How-can-I-seperate-filtered-sum-value-and-overall-sum-value/m-p/17756#M1205 <HTML><HEAD></HEAD><BODY><P>Hello fellow communities,</P><P></P><P>Here I have and issue where i am required to categorize total quantity of particular item into their quantity range. When it's filtered and only 1 item is selected, it shows perfectly. </P><P></P><P>How can I sum the quantity by distinct purchasing document then group according to quantity range?</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/203620_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>But it's no purchasing document is selected at all, it will sum all the quantity and let it all be above 30,001.</P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/203621_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P><IMG alt="" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/203622_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P><P>How can I sum the quantity by distinct purchasing document then group according to quantity range?</P></BODY></HTML> Wed, 22 Dec 2021 15:42:54 GMT Anonymous 2021-12-22T15:42:54Z How can I seperate filtered sum value and overall sum value? https://community.qlik.com/t5/App-Development/How-can-I-seperate-filtered-sum-value-and-overall-sum-value/m-p/17756#M1205 <HTML><HEAD></HEAD><BODY><P>Hello fellow communities,</P><P></P><P>Here I have and issue where i am required to categorize total quantity of particular item into their quantity range. When it's filtered and only 1 item is selected, it shows perfectly. </P><P></P><P>How can I sum the quantity by distinct purchasing document then group according to quantity range?</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/203620_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>But it's no purchasing document is selected at all, it will sum all the quantity and let it all be above 30,001.</P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/203621_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P><IMG alt="" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/203622_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P><P>How can I sum the quantity by distinct purchasing document then group according to quantity range?</P></BODY></HTML> Wed, 22 Dec 2021 15:42:54 GMT https://community.qlik.com/t5/App-Development/How-can-I-seperate-filtered-sum-value-and-overall-sum-value/m-p/17756#M1205 Anonymous 2021-12-22T15:42:54Z