Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Matthew,
Could you provide a demo that would give more context to your question?
Like this?
AWESOME! that easy !
thanks so much
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