How to show the Low N and Top N values in Bar Chart?

[#1]

Hi All,

I would like to ask for some advice on how to create a BAR Chart in QV that can show the top 1 to 10 dimension values, top 11 to top 20 dimension values, top 21 to top 30 dimension values, etc..? I created a slider bar (with step 10,20,30,40,50,60, etc.) on the side of the bar chart to control which range of data that user can select. If user click on 10, then it will show Rank 1 to 10 records, when user clicks on 20, then it will show Rank 11 to 20 records, etc... Pls advise..

Thanks.

YY

[Gysbert_Wassenaar]

See this discussion: How to show top 3 and bottom 3 values

[#3]

Hi Gysbert,

Thanks for your message. Just found out that this issue can be solved by creating a rank function and bound it into the Low N and Top N variables. Then put this into a if then condition under the set expression of the measure field of a chart.

Thanks,

YY

[#4]

hi,

use rank function along with if condition in the Bar chart expression.