topic Re: Cyclic Group in QlikView

Cyclic Group

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

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!

Re: Cyclic Group

vishsaggi — Thu, 28 Sep 2017 18:09:32 GMT

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')

Re: Cyclic Group

vvira1316 — Thu, 28 Sep 2017 18:12:54 GMT

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

Re: Cyclic Group

Anonymous — Thu, 28 Sep 2017 18:22:19 GMT

Where are you selecting the trigger? Sheet properties?

Re: Cyclic Group

Shiva123 — Thu, 28 Sep 2017 18:29:58 GMT

its in document properties

Re: Cyclic Group

vvira1316 — Thu, 28 Sep 2017 18:34:52 GMT

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.

Re: Cyclic Group

vishsaggi — Thu, 28 Sep 2017 18:37:45 GMT

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

Change the field names accordingly.

Re: Cyclic Group

Anonymous — Thu, 28 Sep 2017 18:44:33 GMT

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

Re: Cyclic Group

Anonymous — Thu, 28 Sep 2017 18:45:50 GMT

Oh okay, will try with the variable.