Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
konHi
Partner - Contributor III
Partner - Contributor III

Jump to a Cycle Group element

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.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Andrea_Ghirardello

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
konHi
Partner - Contributor III
Partner - Contributor III
Author

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 🙂