How to get the used expression?

[#1]

Hi All,

I hope someone already solved my challenge: I use a group of expressions like Sum(Qty) and Sum(Sales). Now I want to show certain other objects (e.g. credits or reference codes) only if the Sum(Sales) expression is shown in the first object. Does anyone know how to reference which of the grouped expressions is currently used?

Thank you all in advance!

Florian Kausler

[johnw]

So far as I know, there is no way to reference the currently-selected expression from a group.

That said, you can fake it up by creating field names corresponding to the expressions, putting those field names in a group, and then referencing getcurrentfield(group) inside of a SINGLE expression in the chart. The behavior will be basically the same as grouped expressions, but now other objects can know which "expression" has been selected. Yeah, it's a workaround, but it works.

See attached example.

EDIT: Or not. That doesn't look like the right example. I have way too many examples on my hard drive. I'll try to find an appropriate example.

EDIT: I think I have the right example attached now. In the example, we reference the selected "expression" to change the sort order. But you can make the same reference in other objects as well.

[pratap6699]

object right click-->expression-->group-->cyclic/dropdown-->use anynumber of expressions in group

[jrdunson]

John,

Hello,

just wanted to ask a questions on this... the illustration you give is for dimensions

What if I have cyclic expressions?  Is there a way to show the labels for two cyclic expressions?

It defaults to <get first expression label> Is there a way to display both labels? (i.e. from my second expression?)

[buzzy996]

see attached

[jrdunson]

Hey, thanks, but as I stated, you listed a way of seeing dimensional cyclic groups, not expression cyclic groups ...How can I get the name of the Expression Cyclic Groups?

[johnw]

I've probably misunderstood your question, since the default behavior is to show the label of both cyclic groups. Not as the "title in chart", but as the legend for your two cyclic expressions. I fiddled around in the attached to line up the cycle icons next to the expression label, but there were no special settings or anything.

[jrdunson]

Ok... thanks... I can just forego a chart title ...

[johnw]

I'm not your users, but I like it.

[jrdunson]

thanks again