Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Do like below, May be?
sum({<field1=p({<field2 = {"=Count(DISTINCT ip) > 1"}>} field2) >}value)
Re: how to compare two field values
Try to share a sample qvw and explain expected output against that.