Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

chandni90
Contributor

Cyclic Group

Hi,

I want the field 'BU Group' to automatically select a particular value when the 'Ultimate Customer' cyclic group is selected. How do I achieve this? Thanks!

bkj.png

8 Replies
vishsaggi
Esteemed Contributor III

Re: Cyclic Group

What is that particular value you want the BU Group to select. ?

May be write like in a trigger -> Actions -> Select in Field -> BU Group

= IF(GetCurrentField(YourGroupName) = 'Ultimate Customer', 'YourBUGroupvalue')

vvira1316
Valued Contributor II

Re: Cyclic Group

Hi.

I tried similar in using one of my cyclic group but going different value in cyclic group is not being treated as select or change so trigger-action is not getting associated.

BR,

Vijay

chandni90
Contributor

Re: Cyclic Group

Where are you selecting the trigger? Sheet properties?

shivadonka
Contributor

Re: Cyclic Group

its in document properties

vvira1316
Valued Contributor II

Re: Cyclic Group

Hi Chandni,

The Cyclic group doesn't show up in fields but I've inline table on which I had created cyclic group. I was using it. Its value does show up in fields section on triggers tab,

Please see screenshots below.

InlineTbl2.png

TriggersTab.PNG

vishsaggi
Esteemed Contributor III

Re: Cyclic Group

No in document properties. But create a variable first then use variable event trigger on OnChange

LIke create a variable like

Ctrl+Alt+V

vChange = IF(GetCurrentField(Cyclic1) = 'ProblemDetail', 1, 0)

In document properties Triggers tab use like

Capture.PNG

Change the field names accordingly.

chandni90
Contributor

Re: Cyclic Group

Tried it, not working. What am I doing wrong?

send1.PNG

send2.PNG

send3.PNG

chandni90
Contributor

Re: Cyclic Group

Oh okay, will try with the variable.