Jump to a Cycle Group element

[konHi]

Hi guys,

I know that I can get the current Cycle Group level with =GetCurrentField(XXX). Is it also possible to set a specific level of the dimension with a button?

XXX-Cycle : [Level 1] [ Level 2] [Level 3] [Level 4]

Button: -> go to [Level 3]

Thank you for answering.

[Andrea_Ghirardello]

Hi,

You should find a quick solution here:

Retrieving Groups and their contents via API

Change selected hierarchy through COM API

[Gysbert_Wassenaar · Accepted solution]

Create a small inline table in the script with the fields:

FieldList:

Load * inline [

LevelField

Level 1

Level 2

Level 3

Level 4

];

After reloading you can create a listbox for the new LevelField field to select the field you want. Instead of a cyclic group you now use a calculated dimension: =[$(=LevelField)]

See attached example

[konHi]

An interesting solution. Thank you.

I tried it, it works. I also added an aditional Field with user friendly descriptions, perfect!

a Drill Through or Cycle Dimension works as well the only problem is that QlikView doesn't show the cycle / Drill buttons. 😞

Any solutions here? without macros please 🙂