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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
spikenaylor1
Creator
Creator

get a distinct list from expression results

I have a list of people, for each person I have a % expression in this for documents correct. 

I end up with the list of people with the expression result ranging from 0% to 100%

 

I am interested in seeing all the peoples results, but then being able to filter the ones with 100%

How can I generate a list showing the distinct % results so when selecting the 100% in the list it filters out all those who have not reached 100%

my expression for the % is

num(Count({<RFT = {'YES'}>} RFT)/Count(Document),'.%')     Label - RFT

 

 

regards

 

 

 

 

 

Labels (1)
1 Reply
sunny_talwar

May be create a list box object with this expression

Aggr(
Only({1<Person = {"Count({1<RFT = {'YES'}>} RFT)/Count({1} Document) = 1"}>} Person)
, Person)