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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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