Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

showing cyclic group selection in title

Hi,

Is it possible to put the cyclic or drilldown selection value in the title of a chart ?

I have a drilldown group as a dimension in a chart and based on the values of the group, I want to show the same in the chart title.

so based on the next drilldown level, the title should change to 'Count per subunit' ...

CHECK.JPG

8 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

In your title put:

='Count by ' & GetFieldSelection('yourgrouphere')

I think it's GetFieldSelection() you need to use - check the F1 help for the other similar functions if not. One of them definitely works! The key is to put your group name in the single quotes.

Hope this helps,

Jason

adhudson
Creator II
Creator II

Hi,

     Lets say you have a drill down group called 'DD_Year_Month' .

     To display the values of the current selection you can use the following.

    

subfield(GetCurrentSelections('DD_Year_Month'),': ',2)

adhudson
Creator II
Creator II

Hi,

     By using subfield function, you will also be able to get the Selected Field Name.

     Hope this helps you.

Regards

Hudson

Not applicable
Author

Hi

Use ='Count by ' GetCurrentField('GroupName')

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

Kind Regards,

Footsie

Jason_Michaelides
Luminary Alumni
Luminary Alumni

GetCurrentField() - that's the one!!  (Knew it was one of them...)

Not applicable
Author

count per & GetCurrentfield(drilldown name) should work.Put the drilldown name without any single or double quotes

Not applicable
Author

It worked for me, but without the quotes ('').

mohamed_ahid
Partner - Specialist
Partner - Specialist

Hi,

GetCurrentField ("Cyclic group")