Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

avastani
Contributor II

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
Honored Contributor II

Set the active field in a cyclic group

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

Set the active field in a cyclic group

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

Set the active field in a cyclic group

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

:-J

avastani
Contributor II

Set the active field in a cyclic group

not, only as a macro

Not applicable

Re: Set the active field in a cyclic group

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.

michael_gardner
Contributor III

Re: Set the active field in a cyclic group

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.

Highlighted
rustyfishbones
Honored Contributor II

Re: Set the active field in a cyclic group

rustyfishbones
Honored Contributor II

Re: Set the active field in a cyclic group

I tried that Micheal could not get it to Work?

koresaket
New Contributor

Re: Set the active field in a cyclic group

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

Community Browser