Odd distinct values?

Thu, 18 Aug 2011 15:21:04 GMT

Hi,

I'm trying to workout the distinct number of schools, in a particular College.

It's a simple set analysis expression which should be straight forward, but I'm not getting the correct number of Schools within the College.

eg.(see attached)

I get 8 schools for the College JJO

and 14 schools for QFII.

There should be 7 schools in JJO and 11 in QFII

Any ideas on how this expression should be changed?

Many thanks!

swuehl — Thu, 18 Aug 2011 16:06:16 GMT

You might want to consider replacing the {1< at the start of your set expression to {$<

taken the current selection into account.

I noticed that you somehow exclude schools in your current selection, which are not counted then, but get countet in your text box using {1}.

(Use a current selection box to see your active selections)

Regards,

Stefan

topic Odd distinct values? in QlikView