topic Re: cyclic group in QlikView

cyclic group

Tue, 16 Feb 2016 08:30:20 GMT

hi friends, I have a question:

I define tow variables that called G and X and a cyclic group called group.1 with tow fields S.1 and S.2 .

I want to add a value in the variable of X.

I use this code for cyclic group:

G=getcurrentfield("group.1");

$(G) shows S.1 or S.2.//

If(G='S.1' , X=1, X=0)

But always X=0 and G='S.1' is not working. Please help me for this problem. TNX

Re: cyclic group

sunny_talwar — Tue, 16 Feb 2016 11:00:18 GMT

What about this?

If($(G)='S.1', 1, 0)

Re: cyclic group

PradeepReddy — Tue, 16 Feb 2016 11:11:18 GMT

create variable 'X' like this..

=if(GetCurrentField("group.1")='S.1',1,0)

Re: cyclic group

Anonymous — Tue, 16 Feb 2016 11:46:24 GMT

Go cyclic group and given the variable under the cyclic group

Re: cyclic group

Wed, 17 Feb 2016 04:51:36 GMT

Thanks, problem is solved

Re: cyclic group

Wed, 17 Feb 2016 04:52:06 GMT

Thanks, problem is solved

Re: cyclic group

Anonymous — Thu, 18 Feb 2016 19:43:33 GMT

Hi Abolfazl,

I'm glad to hear you problem is solved. Please take a moment to mark the reply that solved your question as the Correct Answer, so that it will show this thread as Answered. For step by step instructions on how to do this, check out this Community Tip. If you solved your own issue, please post your solution so that it may help others in the future.

Thank you,

Qlik Community Moderation Team

Re: cyclic group

Mon, 29 Feb 2016 11:15:59 GMT

hi, OK

Re: cyclic group

Anonymous — Wed, 09 Mar 2016 20:07:05 GMT

That formula really helped me, but my formula has red squiggly lines underneath indicating the expression editor does not like the cyclic group name with " " around it.

It works. Can we just chalk this up to another one of those flaws in the Expression editor?

Re: cyclic group

PradeepReddy — Thu, 10 Mar 2016 05:46:28 GMT

by default you will get red squiggly lines.. that is not not an issue.. your expression will work as expected..

Re: cyclic group

chetanpatel — Fri, 04 Dec 2020 02:50:19 GMT

=If( GetCurrentField("Period")='Month',1,0) please help me with this equation cyclic group has a value month but it's not giving result where value is matching.