set analysis

[Anonymous]

hello

I have a excel file like bellow:

name  telephone

aaa      2222222

bbb      8888888

bbb      9999999

aaa      2222222

i want to show the names with 2 different phone number like "bbb"

i would appreciate if anyone can help me in writing set analysis.

[jagan · Accepted solution]

HI,

Try like this

Chart: STraight Table

Dimension: Name

Expression: If(Count(Distinct telephone) > 1, Concat(telephone, ',', 0)

Regards,

Jagan.

[Kushal_Chawda]

Create the straight table

Dimension : Name

Expression : Concat ({<Name={"=count(distinct telephone)>1"}>}Name,',')

[martinien]

Hi,

You can concat these simply in a text area with something like

=Concat(DISTINCT {<name={"=Count(telephone)>1"}>} name, ' - ' )

Also keep in mind than you can use the search string in listbox  to find these kind of things quickly :

Martin

[ramasaisaksoft]

Hi Kabir,

PFA..

[PradeepReddy]

see the attachment...

[Anonymous]

Thank you jagan it worked

[Anonymous]

Jagan i missed one condition

we must not have different phone number in each month

fore example if a person have two different numbers in month Jan and Feb it's OK

How can i add month condition in expression?

[Kushal_Chawda]

I think you can use

If(aggr(Count(Distinct telephone),Month,Name) > 1, Concat(telephone, ',', 0)

[Anonymous]

Unfortunately it didn't work.