topic Re: Able to substitute dimension values? in QlikView

Able to substitute dimension values?

Thu, 18 Dec 2014 23:17:39 GMT

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?

Re: Able to substitute dimension values?

julian_rodriguez — Thu, 18 Dec 2014 23:28:36 GMT

Hello totinmic

Please see attachment,

Re: Able to substitute dimension values?

MarcoWedel — Fri, 19 Dec 2014 01:16:09 GMT

Hi,

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

maybe it helps

regards

Marco

Re: Able to substitute dimension values?

Fri, 19 Dec 2014 14:16:25 GMT

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?

Re: Able to substitute dimension values?

MarcoWedel — Fri, 19 Dec 2014 14:37:38 GMT

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

and

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