topic Re: Jump to a Cycle Group element in QlikView

Jump to a Cycle Group element

konHi — Mon, 09 Sep 2013 15:08:39 GMT

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.

Re: Jump to a Cycle Group element

Andrea_Ghirardello — Mon, 09 Sep 2013 15:27:27 GMT

Hi,

You should find a quick solution here:

Retrieving Groups and their contents via API

Change selected hierarchy through COM API

Re: Jump to a Cycle Group element

Gysbert_Wassenaar — Mon, 09 Sep 2013 16:12:16 GMT

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

Re: Jump to a Cycle Group element

konHi — Tue, 10 Sep 2013 09:23:51 GMT

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 🙂