Set Analysis - Search String

[#1]

Hi all,

Is it possible to do a greater than / less than on a string in set analysis, like

SUM({$<Field= {“<= $(Variable)”}>} MeasureField)

where $(Variable) contains a string value?

If not, what should be a good work around for this?

Regards,

Björn

[avinashelite]

IF you have greater than and lesser than parameters than you can try like this :

SUM({$<Field= {“>=$(Variable2)<= $(Variable)”}>} MeasureField)

[#3]

The point is that the greater than / lesser than functionality in set analysis won't work when the Variable contains a string value.

[#4]

Good workable solution without using Set Analysis, thanks!

[avinashelite]

if you have got the answer please mark the correct answer and close this thread

[#6]

Thanks, I did not know the precedes / follows operators and the way to use them in Set Analysis. I tried the following and it worked:

SUM({$<Field= {“Field precedes '$(Variable)'”}>} MeasureField)

I actually used the same field for both Field.