Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
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