https://community.qlik.com/t5/App-Development/Filter-on-conflicting-dimensions/m-p/2155322#M93586 <P>Hi</P> <P>I am trying to setup a DQ report to show where there are conflicting dimensions accross different records.</P> <P>The simplest example that i can think of is, for example where the same customer has been entered with different gender accross multiple records.</P> <P>What formula can i use to filter down just on the customers where there are different genders in this example?</P> Thu, 21 Dec 2023 08:45:50 GMT jono19872002 2023-12-21T08:45:50Z https://community.qlik.com/t5/App-Development/Filter-on-conflicting-dimensions/m-p/2155322#M93586 <P>Hi</P> <P>I am trying to setup a DQ report to show where there are conflicting dimensions accross different records.</P> <P>The simplest example that i can think of is, for example where the same customer has been entered with different gender accross multiple records.</P> <P>What formula can i use to filter down just on the customers where there are different genders in this example?</P> Thu, 21 Dec 2023 08:45:50 GMT https://community.qlik.com/t5/App-Development/Filter-on-conflicting-dimensions/m-p/2155322#M93586 jono19872002 2023-12-21T08:45:50Z https://community.qlik.com/t5/App-Development/Filter-on-conflicting-dimensions/m-p/2155340#M93588 <P>Count(Distinct WhateverDimensionIsDuplicated) &gt; 1</P> <P>Perhaps?</P> Thu, 21 Dec 2023 09:05:17 GMT https://community.qlik.com/t5/App-Development/Filter-on-conflicting-dimensions/m-p/2155340#M93588 Or 2023-12-21T09:05:17Z