Chart Total Count and NullCount problems

Tue, 11 Dec 2012 11:43:33 GMT

Hello all,

My first post here, and I assume it's a silly one!

Due to client confidentiality, I am unable to post the QVW, so I'll try my best to explain the problem and what I'd like resolved.

So, I'm trying to visualise data quality for x client. All data is pulled from the client's database through SQL. The client has 4185 suppliers:

65 percent of those suppliers have VAT Numbers, 35 NULL
45 percent have bank account numbers, 55 percent either have NULL or entry as zero
40 percent have listed cities, 60 percent NULL
etc.

I would like to make a radar chart that shows NULL/0 entry count for each of the above criteria. (So, nullcount radar for VAT would have a count of ~1300, etc.)

This was possible through excluding dimensions and calculated dimensions, by using the following sample expressions:

if([Bank Account Number]<>'NULL' and [Bank Account Number]<>0, count(DISTINCT([Bank Account Number])))

=Count(DISTINCT{$<[Bank Account Number]={"NULL"}>} [Supplier Name])

=Count(DISTINCT{$<[Bank Account Number]={"0"}>} [Supplier Name])

However, clicking the expressions did not link to any data, I assume because no dimensions were entered.

Here's where I'm stuck. The chart should be a drilldown, showing (in order):

Count and NULL count for VAT, bank account, cities, etc
- Would like this to be for ALL suppliers (one radar chart line with value of 1300 VAT nullcount, one radar chart line with value of 2600 VAT total count, etc)
- Obviously showing a radar chart with 4185 distinct lines per 10 data quality tests is not ideal
Depending if the user clicks a NULL count or total count:
1. Show all suppliers with NULL or
2. Show all suppliers with entry
3. Clicking either of these will list all suppliers in a list box

I understand I have not done well with explaining this, but any help would be very much appreciated. This is an amazing community, and I look forward to being able to give back to it someday!

Please don't hesisitate to ask for clarification, as this was probably a confusing post

Thanks,

Joe

topic Chart Total Count and NullCount problems in QlikView

Chart Total Count and NullCount problems