Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ranking in a dynamic group

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?

1 Solution

Accepted Solutions
jjordaan
Partner - Specialist
Partner - Specialist

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

View solution in original post

2 Replies
jjordaan
Partner - Specialist
Partner - Specialist

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

Not applicable
Author

Hi Jeroen

this is great 🙂 Thanks a lot!

Best,

Oliver