how to compare two field values

[kunkumnaveen]

Hello All,

          I need to write a expression in set analysis which should compare between two fields values let say

if field1 value = field2 value  and field2 value has more than one IP then  sum of values(field2=count(distinct ip)>1)

How to write above condition in set analysis plz...

Thanks

[Anil_Babu_Samineni]

Do like below, May be?

sum({<field1=p({<field2 = {"=Count(DISTINCT ip) > 1"}>} field2) >}value)

Re: how to compare two field values

[tresesco]

Try to share a sample qvw and explain expected output against that.