static max for cyclic group

[Anonymous]

hi there,

ı am trying to write static max for cyclic group,

My cyclic groups name is = Cyclic1

And ı have 3 dimensions in it dim1 , dim2, dim3

now I want to write an if statement in the static max box,

but it does not work when I write this (it does not recognize cyclic1)

=if(Cyclic1=dim1,100,50)

it does not work for some reason,

thanks for your helps!

[Anil_Babu_Samineni]

May be this

If(match(getcurrentfield(groupname), 'Cyclic1')=dim1, 100, 50)

[sunny_talwar]

May be try using GetCurrentField() function

GetCurrentField ‒ QlikView

[sunny_talwar]

Did you mean this Anil

=If(GetCurrentField([Cyclic1]) = 'dim1', 100, 50)

[Anonymous]

ı tried but making some syntax error, ı need the whole sentence...

[sunny_talwar · Accepted solution]

Try this

=If(GetCurrentField([Cyclic1]) = 'dim1', 100, 50)

[Anil_Babu_Samineni]

Yes, but perhaps this. Removed single quote

If(GetCurrentField([Cyclic1]) = dim1, 100, 50)

[Anonymous]

thanks! it worked!

the error was lack of [ ] , thank you!

[sunny_talwar]

You def. need the single quotes around dim1....

[Anil_Babu_Samineni]

Yes, that's the drawback. But, it will work. May be team work further versions