Set the active field in a cyclic group

[avastani]

is it possible to set the active field in a cyclic group on a chart based on a selection in another field?

I know we have the Select in Field trigger but that is limited to fields and not extended to groups.

thoughts?

[danielrozental]

You could try with a macro.

groups=ActiveDocument.GetGroups

groups(0).Cycle 1

You could also avoid using a group and just let the user pick the field.

[avastani]

Yes I could, but I wanted to avoid a macro. I guess this would be a good action to include in triggers.

thanks.

[#4]

I would be interested to know if you ever found a solution to this. Thanks!

:-J

[avastani]

not, only as a macro

[#6]

Just to add to this general topic, I discovered that the first field listed in a cyclic group is what the group will default to in a chart.  In case it's helpful to anyone.

[Anonymous]

You can put all the field names you want in the cycle group instead in a Island Table in your Data Model.

Example:

LOAD * INLINE [

    CycleGroup

    FieldName1

    FieldName2

    FieldName3

];

Then put the CycleGroup list box in your application.  In the Chart put the dimension expression =[$(=CycleGroup].  When you choose the Field Name in your CycleGroup List Box the chart should populate with the field.

[rustyfishbones]

This video may help

Qlikview Macro Button for Cyclic Dimensions by RFB 173 - YouTube

[rustyfishbones]

I tried that Micheal could not get it to Work?

[koresaket]

I need to apply the same functionality on drill down group. Please suggest me some solution.