Qlik Community

Ask a Question

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

filter QlikSense

Filtering while using this formula “ Count(distinct Borrower_Group_Name)- Count({<Onboarding_Status = {'J) Sold During The Process'}>} distinct Borrower_Group_Name) ” creates weird results (negative values, graphs not shown, etc).

this is mainly because the second part of the formula is greater than the first one when filter applies.

is there another formula, technique I can apply here? Given that I want to remove the sold assets from all the kPIs and charts

Labels (2)
0 Replies