AND function?

[jim_chan]

Hi guys,

I have a script to write.

OK. I have 2 columns Customer ID(001,002) and Change(A,B).

I would like to see records of Customer ID which have change the "change", at below, Customer ID 'A' as made a change from A to B.

Date	Customer ID	Change
01/01/2016	A	A
02/01/2016	A	B
01/01/2016	B	B

So, i created a calculated dimension - if(change = 'A' AND change = 'B',Customer_ID). It is not working,.......

[Chanty4u]

try

if(change = 'A' or change = 'B',Customer_ID)

[avinashelite]

The above condition will yield you the results only when change has been made by both A and B .. I did not get the your exact requirement ..

try like this

if(change<>Customer_ID,Customer_ID)

[tamilarasu]

Hi Jim,

I am not sure what is your exact requirment. You have mentioed that you are using calculated dimension, so try like below,

=Aggr(If(Concat(Change,'|')='A|B',[Customer ID]),[Customer ID])

[jim_chan]

Hello Avin!

I need a script that only show me customer ID that have made changes. , like the red color square box.

[avinashelite]

would be able to share the sample data for the same

[jim_chan]

sure. ! sample qvw as per attached, Avin

[jim_chan]

tried. not working.

[jim_chan]

tried. not the outcome i am looking for

[anagharao]

Hi,

You could group the data by Customer ID and find out the distinct number of change values.