Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi,
You should find a quick solution here:
Retrieving Groups and their contents via API
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
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 🙂