topic Re: how to name a selection table with a dynamic group? in QlikView

how to name a selection table with a dynamic group?

Wed, 08 Apr 2015 05:36:12 GMT

Hi all

I created a dynamic group, with different aggregations of our customers.

(sinlge-Store, Group, Headquaters)

As you are able to change the levels you are looking at, the name of the selection table has to change as well.

I couln't find any option for that?

Das somebody have an idea?

Thanks for your help

Re: how to name a selection table with a dynamic group?

datanibbler — Wed, 08 Apr 2015 06:23:19 GMT

Hi Oliver,

the label of a chart can also be an expression. You can use the Getfieldselections([Group]) or Getcurrentselections([field]) functions to find out which dimension is currently active.

HTH

Re: how to name a selection table with a dynamic group?

Wed, 08 Apr 2015 10:37:14 GMT

Thanks for your fast reply. I tried "GetCurrentField(BP)" and it worked.

But it shows me the technical name.

When I want to see the user-friendly name, I can do this withs if/else?

But somehow it doesn't work....

=if(GetCurrentField(BP)='BP.Name','BP Outlet')

the field name is BP.Name in this App....