topic Removing rows below threshold on straight table in QlikView https://community.qlik.com/t5/QlikView/Removing-rows-below-threshold-on-straight-table/m-p/718771#M258278 <HTML><HEAD></HEAD><BODY><P>Hello,&nbsp; I need some assistance with removing rows that fall below the threshold I choose.&nbsp; 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.&nbsp; My formula for the average is</P><P><SPAN style="color: #0000ff; font-size: 10pt;"><EM style="color: #575757;">Count</EM></SPAN><SPAN style="color: #575757;"><EM style="font-size: 10pt;"> (DISTINCT CLAIM_KEY)<STRONG style="text-decoration: underline;">)</STRONG>/ (Count (DISTINCT SRC_MBR_HIPPA_ID</EM><SPAN style="font-size: 10pt;"><EM>))</EM></SPAN> </SPAN></P><P></P><P></P><P>Because I have thousands of providers, I only want lines where the Avg Claims per Member is &gt;=10.&nbsp; Any help that can be provided is appreciated.&nbsp; Thank you.</P></BODY></HTML> Mon, 21 Jul 2014 13:00:21 GMT 2014-07-21T13:00:21Z Removing rows below threshold on straight table https://community.qlik.com/t5/QlikView/Removing-rows-below-threshold-on-straight-table/m-p/718771#M258278 <HTML><HEAD></HEAD><BODY><P>Hello,&nbsp; I need some assistance with removing rows that fall below the threshold I choose.&nbsp; 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.&nbsp; My formula for the average is</P><P><SPAN style="color: #0000ff; font-size: 10pt;"><EM style="color: #575757;">Count</EM></SPAN><SPAN style="color: #575757;"><EM style="font-size: 10pt;"> (DISTINCT CLAIM_KEY)<STRONG style="text-decoration: underline;">)</STRONG>/ (Count (DISTINCT SRC_MBR_HIPPA_ID</EM><SPAN style="font-size: 10pt;"><EM>))</EM></SPAN> </SPAN></P><P></P><P></P><P>Because I have thousands of providers, I only want lines where the Avg Claims per Member is &gt;=10.&nbsp; Any help that can be provided is appreciated.&nbsp; Thank you.</P></BODY></HTML> Mon, 21 Jul 2014 13:00:21 GMT https://community.qlik.com/t5/QlikView/Removing-rows-below-threshold-on-straight-table/m-p/718771#M258278 2014-07-21T13:00:21Z