Zero to Hero - 0 can be interesting too!

[#1]

Hi Everyone,

with help from some greate qlikview community members i'm nearly on my way to finishing my first application. Basic, but hey, i'm learning.

So in one of my previous posts i talked about at table show the frequency of how many time and ID appeared in a table this was using a AGGR function.. BUT, how do include 0?

i want to asked the question, "How many ID's are in the table that do not have a status flag" so the "0" would represent that opportunity.

is this something i can incorporate into the  Aggr(Count(ID),ID)  formula?

eg:

FREQUNECY	COUNT
0	345000
1	4899877
2	1233455
3	800000
4	23000
5	12873

so from here i know that there is an opporunity to use 345,000 ID numbers

[#2]

Matthew,

Could you provide a demo that would give more context to your question?

[#3]

Like this?

[#4]

AWESOME! that easy !

thanks so much

[#5]

i know this may seems strange but my data at the moment has no records which meet this criteria,so in other words all ID's appear with a FLAG as 1

but...

i seem to be getting a count at the bottom of the table with a - symbol which is confusing me, i almost expected to see 0 - 0