topic Re: Button to Select in a Cyclic Group? in QlikView

Button to Select in a Cyclic Group?

MalcolmCICWF — Fri, 25 Mar 2016 16:34:26 GMT

I am not super familiar with macros, but I found one online to use a button to select a specific field in a cyclic group. The problem is it seems to work once and then it wont work again. Anyone have any experience with macros or more specifically, a macro or way to select a specific field within a group.

I am using the below to select the number of the field down from the top. I test it, it works, but just the once. Maybe I am missing something to rest the macro....

set group = ActiveDocument.GetGroup("Group Name")

set gp = group.GetProperties

group.Cycle 5

Re: Button to Select in a Cyclic Group?

Gysbert_Wassenaar — Fri, 25 Mar 2016 16:36:23 GMT

Not a good idea to be honest. If you want to select a field to use as dimension use the technique explained here: Customisable Straight (and Pivot) Tables - more food for thought

Re: Button to Select in a Cyclic Group?

Chanty4u — Fri, 25 Mar 2016 16:37:26 GMT

chk dis

Qlikview Macro Button for Cyclic Dimensions by RFB 173 - YouTube

https://community.qlik.com/message/460370#460370