topic Values cyclic expression group in QlikView

Values cyclic expression group

Wed, 25 Nov 2009 00:08:54 GMT

Hello all, I have a cuestion. How I can know the value selected in a cyclic expression group. For example I have a Cyclic Expression with 2 field (Ambassador and Country Client) I need to know what is selected by the users to see a pivot table.

Values cyclic expression group

Miguel_Angel_Baeyens — Wed, 25 Nov 2009 00:18:16 GMT

Hello Marco,

Use

=GetCurrentField(groupName)

Values cyclic expression group

Wed, 25 Nov 2009 01:15:11 GMT

it work..!! thank you Miguel ;). But I have a new cuestion. How I can assign a value to my group with a macro for example?

I tried this expression:

ActiveDocument.Fields("My Group").Select "Ambassador"

but this don't work... 😞

Values cyclic expression group

Miguel_Angel_Baeyens — Wed, 25 Nov 2009 01:25:47 GMT

Check here. It's something similar.

Values cyclic expression group

Wed, 25 Nov 2009 01:39:33 GMT

mmm.. the example is not the same, because I looking for a instruction that allows me to select a value in a cyclic group predefined. For example I have a Cyclic Expression with 2 field (Ambassador and Country Client) and I need insert in a report a button that change the option. If the user selects Country Client (for example) when presses the button then change value of group by Ambassador and vice versa.

Values cyclic expression group

Miguel_Angel_Baeyens — Wed, 25 Nov 2009 17:58:58 GMT

Here you are my try:


sub set_group_field
 set gp = ActiveDocument.GetGroup("GroupName")
 do while gp.GetActiveField.Name <> "FieldName"
 gp.Cycle 1
 loop
end sub

You have to change manually "FieldName" for the fieldname you want your users check or use.

Values cyclic expression group

Wed, 25 Nov 2009 19:47:31 GMT

Thnk you Miguel it was very good..!! finaly my macro was so :

set gp = ActiveDocument.GetGroup("Gr Customer")
if gp.GetActiveField.Name = "Ambassador" then
gp.Cycle 1
end if

thanks again for everything bye...

Re: Values cyclic expression group

koresaket — Fri, 14 Nov 2014 06:53:12 GMT

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