topic Re: Capturing the selected dimension in a cyclic group in QlikView

Capturing the selected dimension in a cyclic group

Tue, 24 May 2011 04:58:23 GMT

Hi,

I have a Pie Chart in which I show three dimensions as a cyclic group.Now,What I need is I need to capture as to which particular dimension has

been clicked.I want to capture the Label given for the dimension corresponding to the dimension for which I am presently viewing the pie chart.

Please let me know as to how can I achieve this.

Re: Capturing the selected dimension in a cyclic group

yasus — Tue, 24 May 2011 05:29:22 GMT

=GetCurrentField([GroupFieldName])

Re: Capturing the selected dimension in a cyclic group

kaushiknsolanki — Tue, 24 May 2011 06:07:43 GMT

Hi,

Below code will give you the name of the dimension selected in group.

Sub Get_Dim

groups=ActiveDocument.GetGroups

set fld = groups(0).GetActiveField

msgbox fld.name

End Sub

Regards,

Kaushik Solanki

Re: Capturing the selected dimension in a cyclic group

Tue, 24 May 2011 10:21:48 GMT

Hi,

I did do whatever Mr Kaushik and Mr Gregor suggested.

Gregor,

My Cyclic Group name is Type Group so can I add [Type Group] in the place of [GroupFieldName].

Kaushik,

Do let me know as to where can I add this Macro.Do I need to add it on all fields present in the cyclic group.

Regards,

Navin Gorapalli

Re: Capturing the selected dimension in a cyclic group

kaushiknsolanki — Tue, 24 May 2011 10:29:18 GMT

Hi,

Go to the Module by Ctrl + M

Click test and then ok

Create a button. Add action -> external -> run macro -> give the macro name as Get_Dim.

Click Apply.

Click on button to check the result.

Regards,

Kaushik Solanki

Re: Capturing the selected dimension in a cyclic group

montubhardwaj — Tue, 24 May 2011 11:02:33 GMT

Hi,

Please see the attached file. The title will change based on your field in the Group. HOpe this is what you are looking for.

Thanks,

Sharma

Re: Capturing the selected dimension in a cyclic group

Wed, 25 May 2011 07:59:22 GMT

Hey Guys,

Thank you for all your help.I have gone with what Gregor had told me and it worked.

Solanki,

Thanks for giving in your valuable inputs.Even your Code worked but in whatever discussions I came acoss people have advised not to use a macro if possible.

Regards

Navin Gorapalli

Re: Capturing the selected dimension in a cyclic group

Wed, 25 May 2011 08:06:34 GMT

Hi Navin,

I see that it is solved. Give Gregor's answer as answer and Solanki the helping points..

So that it can be used by others in forum, if they have similar question and also thread can be closed.

Just a suggestion.

Edit: Oops.. I see that you already did it..

Regards

Sravan

Re: Capturing the selected dimension in a cyclic group

Anonymous — Thu, 11 Dec 2014 08:30:41 GMT

Thanks Looking for same solution