Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Odd distinct values?

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!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

View solution in original post

1 Reply
swuehl
MVP
MVP

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