How to switch cyclic group when I press on button?

[#1]

Hi guys,

I have a button and graph with cyclic group field in the X axe.

I want to acheive the next result:

When I press on button the cyclic group will be changed from Day to Month.

How can I do it?

Thanks,

Nimrod

[#2]

I think this might help:

http://community.qlik.com/forums/t/17380.aspx

[#3]

No, I need the opposite. 🙂

When I press on the button it will switch the cyclic group field.

[boorgura · Accepted solution]

hey,

you can achieve that using a macro. (Not sure if you intend to do so)

sample code:

set group = ActiveDocument.GetGroup("CyclicGroupNamel")
set gp = group.GetProperties
gp.FieldDefs(0).Name="FieldName"
group.SetProperties gp
group.Cycle 2

Let me know if you have any questions.

[#5]

Thanks for your response. it's working but pay attention that your macro is deleting all the options of the cyclic group field.

[#6]

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

[#7]

Does this solution also work for the ajax client?

[koresaket]

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