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

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Removing rows below threshold on straight table

Hello,  I need some assistance with removing rows that fall below the threshold I choose.  I have a straight table with "Provider" as my dimension and 3 expression field - Member Count that counts distinct members, Claim Count that counts distinct claims, and Avg Claims per Member.  My formula for the average is

Count (DISTINCT CLAIM_KEY))/ (Count (DISTINCT SRC_MBR_HIPPA_ID))

Because I have thousands of providers, I only want lines where the Avg Claims per Member is >=10.  Any help that can be provided is appreciated.  Thank you.

0 Replies