topic showing cyclic group selection in title in QlikView

showing cyclic group selection in title

Wed, 04 Apr 2012 06:31:36 GMT

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' ...

showing cyclic group selection in title

Jason_Michaelides — Wed, 04 Apr 2012 07:02:52 GMT

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

Re: showing cyclic group selection in title

adhudson — Wed, 04 Apr 2012 09:03:11 GMT

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)

Re: showing cyclic group selection in title

adhudson — Wed, 04 Apr 2012 09:04:24 GMT

Hi,

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

Hope this helps you.

Regards

Hudson

Re: showing cyclic group selection in title

Wed, 04 Apr 2012 09:50:23 GMT

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

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

Kind Regards,

Footsie

Re: showing cyclic group selection in title

Jason_Michaelides — Wed, 04 Apr 2012 09:51:37 GMT

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

Re: showing cyclic group selection in title

Mon, 11 Mar 2013 00:47:40 GMT

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

Re: showing cyclic group selection in title

Wed, 23 Dec 2015 11:18:04 GMT

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

Re: showing cyclic group selection in title

mohamed_ahid — Tue, 14 Nov 2017 10:47:55 GMT

Hi,

GetCurrentField ("Cyclic group")