topic Re: Identify which expression within a cyclic group is active? in QlikView

Identify which expression within a cyclic group is active?

datanibbler — Wed, 26 Jul 2017 15:02:17 GMT

Hi,

is there any possibility to identify which of the dimensions within a cyclic Group is active?

I have not used These Groups much in the past - for a reason, I assume - but now I have one and no Details are displayed about the Group as a whole on the "expressions" tab of my Chart_dialog.

Can anyone advise me here?

Alternatively I'll have to implement a button to Change a variable which I can use.

Thanks a lot!

Best regards,

DataNibbler

Re: Identify which expression within a cyclic group is active?

stigchel — Wed, 26 Jul 2017 15:19:06 GMT

For cyclic groups you can use

GetCurrentField (group_name)

For cyclic expressions I don't know..

Re: Identify which expression within a cyclic group is active?

datanibbler — Thu, 27 Jul 2017 07:14:09 GMT

Hi Piet,

I know. That's as far as I got 😉 I know you can use that function, it works with grouped dimensions - but it seems there is no way to give a Name to a Group of expressions.

I guess I remember now why I refrained from using cyclic Groups in the past 😉

So I'll do it the old-fashioned way and use either two separate Charts or a button to Switch - that way I have something which I can also use to influence other formulas.

For Starters I guess I'll go for separate Charts since I already have some formulas and stuff in the Chart -which would be doubled if I introduce a second Dimension ...

Thanks a lot!

Best regards,

DataNibbler

Re: Identify which expression within a cyclic group is active?

Frank_Hartmann — Thu, 27 Jul 2017 09:17:11 GMT

You can use a macro to get the active Expression within an Expressiongroup

hope this helps

Re: Identify which expression within a cyclic group is active?

prees959 — Wed, 26 Jun 2019 13:17:35 GMT

Hi Can this macro be used to test what the current dimension is?