topic Set the active field in a cyclic group in QlikView

Set the active field in a cyclic group

avastani — Wed, 17 Aug 2011 20:00:06 GMT

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?

Set the active field in a cyclic group

danielrozental — Thu, 18 Aug 2011 01:50:33 GMT

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.

Set the active field in a cyclic group

avastani — Thu, 18 Aug 2011 11:15:08 GMT

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

thanks.

Set the active field in a cyclic group

Thu, 27 Oct 2011 14:57:16 GMT

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

:-J

Set the active field in a cyclic group

avastani — Fri, 28 Oct 2011 11:48:24 GMT

not, only as a macro

Re: Set the active field in a cyclic group

Fri, 31 Jan 2014 22:07:08 GMT

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.

Re: Set the active field in a cyclic group

Anonymous — Fri, 31 Jan 2014 22:17:09 GMT

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.

Re: Set the active field in a cyclic group

rustyfishbones — Fri, 31 Jan 2014 23:05:05 GMT

This video may help

Qlikview Macro Button for Cyclic Dimensions by RFB 173 - YouTube

Re: Set the active field in a cyclic group

rustyfishbones — Fri, 31 Jan 2014 23:12:37 GMT

I tried that Micheal could not get it to Work?

Re: Set the active field in a cyclic group

koresaket — Fri, 14 Nov 2014 06:52:42 GMT

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

Re: Set the active field in a cyclic group

Qrishna — Thu, 21 May 2015 18:48:47 GMT

Too Late in responding

Please check out my post Set the active field in a cyclic group.qvw

Hope that helps your question.

Krishna

Re: Set the active field in a cyclic group

Anonymous — Thu, 10 Mar 2016 04:55:08 GMT

You can implement it on document level by using Document level Trigger:

<On open> you can set an action Select in field like I have a cyclic group with Product and date.

I have action on opening document Select in field, Field Name --> Product, Search String--> -.