topic Re: Grouped Column-Names in Formula in QlikView

Grouped Column-Names in Formula

Mon, 14 Feb 2011 15:49:19 GMT

Hello,

how can I access the grouped column name in a formula?

for example: in a pivot table

Thanks

Grouped Column-Names in Formula

Mon, 14 Feb 2011 16:26:28 GMT

Is it a Grouped Dimension or Grouped Expression? If it's a Dimension, it is:

=GetCurrentField(GroupName)

I don't believe a Grouped Expression can be referenced that way.

AW:Re: Grouped Column-Names in Formula

Mon, 14 Feb 2011 16:34:50 GMT

Hi,

that's Expression

AW:Re: Grouped Column-Names in Formula

Mon, 14 Feb 2011 16:41:57 GMT

I don't believe there is a way to identify that selection. Expression groups don't have names and can't be referenced by GetCurrentField().

AW:Re: Grouped Column-Names in Formula

johnw — Tue, 15 Feb 2011 02:24:08 GMT

I've handled this in the past by making a fake expression group that's actually a cyclic dimension group. In the attached example, that lets me change the sort order based on which "expression" has been selected.

Re: Grouped Column-Names in Formula

Wed, 04 Jan 2012 23:38:45 GMT

Very nice - I would like to take this one step further by incorporating into a Scatter Chart which appears to work best with 2 dimensions and 2-3 expressions. (3rd expression can be used to affect bubble size).

However I would like the 3rd expression to actually be a group of expressions allowing the user to choose how to size the bubble/data point (ex: Margin %, Deal Size, # of products). And for the selected expression to be listed in the chart. GetCurrentField(GroupName) seems to not apply here for the reasons mentioned above (grouped expressions do not have a name?) Any ideas? (I tried using John's method above which did not carry over well for the Scatter Chart)