Discussion Board for collaboration related to QlikView App Development.
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.
Go to Solution.
Create a small inline table in the script with the fields:
Load * inline [
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
You should find a quick solution here:
Retrieving Groups and their contents via API
Change selected hierarchy through COM API
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 🙂