Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Champion III
Champion III

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
Specialist II
Specialist II

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

Anonymous
Not applicable
Author

Where are you selecting the trigger? Sheet properties?

Shiva123
Creator
Creator

its in document properties

vvira1316
Specialist II
Specialist II

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
Champion III
Champion III

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.

Anonymous
Not applicable
Author

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

send1.PNG

send2.PNG

send3.PNG

Anonymous
Not applicable
Author

Oh okay, will try with the variable.