Bar graph showing just 5 previous, the given and 5 next

[#1]

Hi,

first of all, sorry if I'm not completely clear. English is not my first language.

I'm needing to show in a bar graph just a subset of ranked expresions.

I have 80 branchs and I'm ranking them (the evaluation expression is not simple and uses sets).

Selecting one of the branchs in a variable, I'm able to focus the analysis in this particular branch but not loosing the general panorama:

There is a comparison of KPIs between two selections. The first selection (in green) is my "given".

I would like to show the bar graph with only 11 bars (the green one, the previous 5 and the next 5) but showing the rank position relative to all the branches (for example: #42 #43 #44 #45 #46 #47 #48 #49 #50 #51 #52

I'm not using selections, all the filters in the application are made using sets and the variable set by "#Seleccion 1".

Additionaly, I would like to show in the title the rank possition that has the branch selected (for example #47)

Any clues ?

Thanks in advance !

Bye

[danielrozental · Accepted solution]

Here is my take on this, I bit messy I know, maybe someone can improve it.

Attaching a file to this message didn't work for me, please download it from my profile.

http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.00.40.74/rank.qvw

[#3]

Hola Daniel,

thanks for your answer and sorry for the delay in answering to it.

It is a solution, but with complex expresions it turns into a big mess to follow.

I think that it would be great if barcharts had the ability to show just a subset of values. One way of implementing this would be adding two properties in Presentation - Dimension limitations like Show from and Show to, enabling using expresions to set the range to be showed.

Do you know how to suggest this improvement to QV and if I have a chance to be eard ?

Gracias !

[danielrozental]

You can suggest features right there http://community.qlik.com/content/featurerequest.aspx

Link is also in the top of the page menu links.

Regards