Count Distinct, Set Analysis

pkelly — Fri, 06 Sep 2013 10:23:52 GMT

Hi...

I have created a Dashboard to look at some Credit Analysis...

I have two lines of KPI's on the Dashboard (each with a text box to show each KPI) showing stats for the previous month (cad_HistoricalMonthNumber = 1)...

On the first line I have the Total issues then a site breakdown of same ...

Total Issues Glasgow Oxford...

20 15 5

On the second line, I have a breakdown of the reason codes...

Sales Yard Distribution....

10 5 3

I have a site filter which, when selected, I want to affect the second line only i.e. I do not want the first line of KPI's to be affected by the filters...

I have tried the following with no success for my Total Issues KPI but with no success...

NUM(COUNT({1}DISTINCT {$<cad_HistoricalMonthNumber = {1}> } %IssueKeyHeader), '#,##0;(##,##0)')

Am sure i am doing something basic wrong and would be grateful for any assistance...

Thanks

Paul

Re: Count Distinct, Set Analysis

swuehl — Fri, 06 Sep 2013 10:28:43 GMT

You are including to set identifiers here, I think that is the issue. Try like

NUM(COUNT( DISTINCT {1<cad_HistoricalMonthNumber = {1}> } %IssueKeyHeader), '#,##0;(##,##0)')

Re: Count Distinct, Set Analysis

pkelly — Fri, 06 Sep 2013 10:31:31 GMT

Thanks swuehl - spot on...

topic Re: Count Distinct, Set Analysis in QlikView

Count Distinct, Set Analysis

Re: Count Distinct, Set Analysis

Re: Count Distinct, Set Analysis