Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Able to substitute dimension values?

I have a simple bar chart with Name as dimension and Revenue as expression.  There are thousands of long names, so the x axis is very cluttered.  I would like to replace the Names with a simple count (1, 2, 3, 4) so that the names are anonymous but identifiable, and the x axis is less crowded.  Is this possible?

1 Solution

Accepted Solutions
MarcoWedel

=Aggr(Rank(Sum({$<NAME=>}REVENUE)), NAME)

and

=Aggr(Rank(Sum({$<NAME=>}REVENUE)), NAME)&': '&NAME

View solution in original post

4 Replies
julian_rodriguez
Partner - Specialist
Partner - Specialist

Hello totinmic

Please see attachment,

20141218 - 1.JPG

MarcoWedel

Hi,

I added a numerical reference in the legend to your solution:

QlikCommunity_Thread_146270_Pic1.JPG

QlikCommunity_Thread_146270_Pic2.JPG

maybe it helps

regards

Marco

Not applicable
Author

Thank you, very helpful!

When I make a selection on Names, it resets the rank.  For example, if I select the Names ranked 11-20, the x axis resets to 1-10.  How do I adjust the formula to disregard the current selection of Name?

MarcoWedel

=Aggr(Rank(Sum({$<NAME=>}REVENUE)), NAME)

and

=Aggr(Rank(Sum({$<NAME=>}REVENUE)), NAME)&': '&NAME