Create Flag if multiple values for Dimension B exist for value of Dimension A

[paul2]

Hi all, 

I am new to qlick sense and ran into an issue that I was unable to solve so far. 

The problem is like this:

My dataset includes multiple Customers (A,B,C), as well as information on the market where they are active (1,2,3). For each customer there can be multiple entries (Jan 2018, Feb 2018, etc.). 

Now, I want to flag all those customers (e.g. A)  where the market is not equal for all entries (e.g. it is 1 in Jan 2018, but 2 in Feb 2018) to find potentially faulty entries. 

Is there a way to perform such an analysis in qlik sense?

Thanks in advance, 

Paul 

[sergio0592]

Hi,

Maybe try with

if(count(TOTAL <Customer>  distinct Market)=1,0,1)