syntax issue

[Anonymous]

=Dual(Replace(Class({<field={'Value1'}>}field,Range2),'<= x <', '-'),Class({<field={'Value2'}>}field,v_Range2))

am getting a syntax error in this,highlighted in pink,

how to resolve this.

[petter]

You are trying to use a set expression with a function that is not an aggregate function.

Set expression may only be used with aggregation functions. The Class()-function is not one of those. So that is why you get a syntax error in your expression....

[niclaz79]

Hi,

Class() does not allow for set expression in the syntax.

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ConditionalFunctions/c...

[Anil_Babu_Samineni]

The set analysis is used when you have Aggregate functions like Sum, Count, Max and Min.. But, You may try this? Before attempt think which object it is, For sure this is not a dimension and Script

=Dual(Replace(Class(Only({<field={'Value1'}>}field),Range2),'<= x <', '-'),Class(Only({<field={'Value2'}>}field),v_Range2))

[Anonymous]

this expression is written in dimension tab

[Anil_Babu_Samineni]

Will make one shot for you, Would you like to attach sample?