topic Total minus selected count in QlikView

Total minus selected count

qv_bazz_10 — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I'm trying to add an object to count total minus selected values you can see highlighted in yellow in the "Current Selection" object for the field "Siti.COD_STRUMENTO_PDR":

As you can see, the total is 158999 and 158967 is the total of selected values, so the number i'd like to have in the new object is 32 (with or without the two totals, even the simple result of the substraction is perfect):

158999 -

158967 =

Can anybody help me? N.B. I can't work on the scritp and i can't upload the file because i'm using a shared document.

Thanks in advance,

Andrea

Re: Total minus selected count

sunny_talwar — Fri, 14 Oct 2016 16:46:41 GMT

May be like this in a text box object

Count({1} Siti.COD_STRUMENTO_PDR) - Count(Siti.COD_STRUMENTO_PDR)

Re: Total minus selected count

Anil_Babu_Samineni — Fri, 14 Oct 2016 17:04:02 GMT

Try this

Sum(total field) - sum({1<field = {$(=getfieldvalues(field))}>}field)

Re: Total minus selected count

qv_bazz_10 — Mon, 17 Oct 2016 07:29:03 GMT

@ Sunny and Anil: i tried both your expressions but i didn't get the result i was searching for. Anyway, triyng them, I found the solution with the function "GetExcludedCount":

=GetExcludedCount (Siti.COD_STRUMENTO_PDR)

Thanks a lot for your help!

Andrea