topic Re: syntax issue in QlikView

syntax issue

Anonymous — Wed, 04 Jul 2018 10:44:13 GMT

=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.

Re: syntax issue

petter — Wed, 04 Jul 2018 11:01:04 GMT

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....

Re: syntax issue

niclaz79 — Wed, 04 Jul 2018 11:01:56 GMT

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/class.htm

Re: syntax issue

Anil_Babu_Samineni — Wed, 04 Jul 2018 11:24:33 GMT

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))

Re: syntax issue

Anonymous — Wed, 04 Jul 2018 11:33:32 GMT

this expression is written in dimension tab

Re: syntax issue

Anil_Babu_Samineni — Wed, 04 Jul 2018 13:34:58 GMT

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