topic Re: Ranking in a dynamic group in QlikView

Ranking in a dynamic group

Mon, 27 Apr 2015 06:08:07 GMT

Hi all

I use a dynamic group as a dimension to show our customer performance.

To show the customer performance related to others I use small diagrams in the table.

To calibrate those diagrams (Rang) I use this formula

max(total aggr(sum({<Fact.Type = {'Sales'}>}Fact.Net_Rev_EUR), BP.Name))

but instead of "BP.Name", that is the lowest level within my dynamic group, I would like to have the current selection within the dynamic group.

The name of my dynamic group is BP.Group

How can I do this?

jjordaan — Mon, 27 Apr 2015 06:20:16 GMT

Hi Oliver,

You can use the name of the cyclic within dollar sign expansion.

Like this

max(total aggr(sum({<Fact.Type = {'Sales'}>}Fact.Net_Rev_EUR), [$(=GetCurrentField([Cyclic Group Name]))]))

Hope this helps

Mon, 27 Apr 2015 06:39:51 GMT

Hi Jeroen

this is great 🙂 Thanks a lot!

Best,

Oliver