Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count and only display counts of one

I want to count how many RxNo are the same and the only display the ones that have a count of one?

Count((RxNo) and (RxNo) = '1')

1 Solution

Accepted Solutions
sunny_talwar

May be this:

Count({<RxNo = {"=Count(RxNo) = 1"}>}RxNo)

View solution in original post

1 Reply
sunny_talwar

May be this:

Count({<RxNo = {"=Count(RxNo) = 1"}>}RxNo)