Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
avastani
Partner - Creator III
Partner - Creator III

Set the active field in a cyclic group

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?

11 Replies
danielrozental
Master II
Master II

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
Partner - Creator III
Partner - Creator III
Author

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

thanks.

Not applicable

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

:-J

avastani
Partner - Creator III
Partner - Creator III
Author

not, only as a macro

Not applicable

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
Not applicable

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

I tried that Micheal could not get it to Work?

koresaket
Contributor II
Contributor II

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