help for set analysis

[saumyashah90]

i have var1,var2,field1.

i have condition if (var1>var2 and var1>'123' and var1<'456',concat(field1))

i kept it in set analysis in this way

concat(if({< var1>var2, var1>{'123'}, var1<{'456'} >}  field1)

it is showing error for 1st curly bracket.

[sujeetsingh]

See this may help you

[saumyashah90]

I am good with two and conditions, only problem is with three or more and conditions

[#4]

Hi,

i would rather write sth like

concat( {set}  if (var1 > var 2, field))

where set =  {< var1={">123 < 456"}  >}

In fact, I do not know if you may write the "var1 > var2" inside the set because there is already a limitation on var1.

Fabrice

[jagan]

Hi Saumya,

Try this

if (var1>var2 and var1>123 and var1<456,concat(field1))

Remove single quotes and check.

Regards,

Jagan.

[saumyashah90]

Set thing is not working

[saumyashah90]

nope not working

[#8]

Hi,

Try this...

if(var1>var2,if(var1>'123',if(var1<'456',concat(field1))))

Regards,

Anju

[jagan]

Hi Saumya,

Can you attach some sample data so that it would be easier to solve.

Regards,

Jagan.