topic Re: Cyclic Group and Dimension Name in QlikView

Cyclic Group and Dimension Name

jduenyas — Wed, 25 Nov 2020 16:16:04 GMT

Hello all

I would like to display the name of the dimension selected from a cyclic group in the Chart Title area so that for instance it will show:

Orders by Month or

Orders by Industry or

Orders by Department etc

when the appropriate dimension is selected from the Cyclic Group.

Is there a way to discern the name of the selected dimension?

(Dimentionality() gives the number of dimensions in the "Used Dimension" but not their names)

Thanks

sunny_talwar — Thu, 07 Sep 2017 00:59:02 GMT

Use GetCurrentField() function

arvind_patil — Thu, 07 Sep 2017 04:29:44 GMT

Hi Josh,

Your Title is like below:

='Orders by '&GetCurrentField(Group Name)

Thanks,

Arvind Patil

jduenyas — Thu, 07 Sep 2017 16:34:54 GMT

I wish I could have given both of you "Correct Answer"

I chose Arvind just because his answer was more complete.

Nevertheless, I thank you. I always follow your replies to questions.

Josh

sunny_talwar — Thu, 07 Sep 2017 16:36:57 GMT

As long as your get what you want, we are all good

Best,

Sunny

arvind_patil — Fri, 08 Sep 2017 06:13:53 GMT

Hi josh,

I am Also following Sunny . So I think you chose my answer as correct then also its his success.

Thanks,

Arvind Patil