https://community.qlik.com/t5/App-Development/filter-QlikSense/m-p/1688006#M63813 <P>Filtering while using this formula “ Count(distinct Borrower_Group_Name)- Count({&lt;Onboarding_Status = {'J) Sold During The Process'}&gt;} distinct Borrower_Group_Name) ” creates weird results (negative values, graphs not shown, etc).</P><P>this is mainly because the second part of the formula is greater than the first one when filter applies.</P><P>is there another formula, technique I can apply here? Given that I want to remove the sold assets from all the kPIs and charts</P> Sat, 16 Nov 2024 02:52:29 GMT yousra_badra 2024-11-16T02:52:29Z https://community.qlik.com/t5/App-Development/filter-QlikSense/m-p/1688006#M63813 <P>Filtering while using this formula “ Count(distinct Borrower_Group_Name)- Count({&lt;Onboarding_Status = {'J) Sold During The Process'}&gt;} distinct Borrower_Group_Name) ” creates weird results (negative values, graphs not shown, etc).</P><P>this is mainly because the second part of the formula is greater than the first one when filter applies.</P><P>is there another formula, technique I can apply here? Given that I want to remove the sold assets from all the kPIs and charts</P> Sat, 16 Nov 2024 02:52:29 GMT https://community.qlik.com/t5/App-Development/filter-QlikSense/m-p/1688006#M63813 yousra_badra 2024-11-16T02:52:29Z