Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get current selection in the Drill down /cyclic group field? and what we can say if use of cyclic and drill down?

How to get current selection in the Drill down /cyclic group field? and what we can say if use of cyclic and drill down?

thanks in advance

2 Replies
dmohanty
Partner - Specialist
Partner - Specialist


Hi Manoj,

You can use the function GetCurrentField as:

GetCurrentField(GroupName)


Returns the name of the currently active field in a group.

sunilkumarqv
Specialist II
Specialist II

suppose your cyclic GroupName is Loc_Cust=Location,customer

Field1=Location,

Field2=customer

similarly repeat the process

Past these below exp into your window title on chart properties genaral tab  and rename Field1 ,Field2 with your cyclic group name

='Current selections ' & If(GetSelectedCount(Field1)>0, GetFieldSelections(Field1)) &' ' &

  If(GetSelectedCount(Field2)>0, GetFieldSelections(Field2))

Finally A list box may contain a cyclic or drill-down group. If a drill-down group is used, selecting a single value in the list box will cause the list box to drill down and switch to the next underlying field in the group. Drilling back up can be accomplished by clicking the drill-up icon in the list box caption.