topic Re: static max for cyclic group in QlikView

static max for cyclic group

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 02 Nov 2017 12:26:10 GMT

May be this

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

sunny_talwar — Thu, 02 Nov 2017 12:26:47 GMT

May be try using GetCurrentField() function

sunny_talwar — Thu, 02 Nov 2017 12:29:38 GMT

Did you mean this Anil

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

Anonymous — Thu, 02 Nov 2017 12:30:20 GMT

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

sunny_talwar — Thu, 02 Nov 2017 12:31:24 GMT

Try this

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

Anil_Babu_Samineni — Thu, 02 Nov 2017 12:32:47 GMT

Yes, but perhaps this. Removed single quote

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

Anonymous — Thu, 02 Nov 2017 12:35:39 GMT

thanks! it worked!

the error was lack of [ ] , thank you!

sunny_talwar — Thu, 02 Nov 2017 12:36:10 GMT

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

Anil_Babu_Samineni — Thu, 02 Nov 2017 12:56:21 GMT

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