topic How to switch cyclic group when I press on button? in QlikView

How to switch cyclic group when I press on button?

Wed, 27 Oct 2010 13:56:04 GMT

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

How to switch cyclic group when I press on button?

Wed, 27 Oct 2010 14:04:08 GMT

I think this might help:

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

How to switch cyclic group when I press on button?

Wed, 27 Oct 2010 14:33:13 GMT

No, I need the opposite. 🙂

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

How to switch cyclic group when I press on button?

boorgura — Wed, 27 Oct 2010 15:25:54 GMT

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.

How to switch cyclic group when I press on button?

Wed, 27 Oct 2010 17:02:35 GMT

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

How to switch cyclic group when I press on button?

Fri, 07 Jan 2011 07:13:28 GMT

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

Re: How to switch cyclic group when I press on button?

Tue, 07 Aug 2012 12:25:03 GMT

Does this solution also work for the ajax client?

Re: How to switch cyclic group when I press on button?

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

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