Issue with Block chart top10 and Bottom10 values

[mayankraoka]

Hi Team,

I am trying to show top10 and bottom10 sales values of customer in block chart.I tried to limit the dimension by dimension limit tab and showing largest 10 for top 10 and smallest 10 for bottom 10.The issue here I am facing is getting the correct value for top10.But for bottom I am not getting any data.The reason I can see is in my data there are certain values with negative numbers.

Is there any way we can show bottom 10 values?

Please let me know in case of any questions.

Regards,

Mayank

[Kushal_Chawda]

may be try with this expression instead of Dimension limit

=sum({<BlockChartDimesion={"= rank(sum(Amount),4)<=10"}> +<BlockChartDimesion={"= rank(-sum(Amount),4)<=10"}>}Amount)

[mayankraoka]

They are 2 different charts 1 is for top 10 and 1 is for bottom 10.It will get enabled on button selection for top and botttom.

[mayankraoka]

even I use the above expression ,I am getting error Positive andnegative vaues in the chart

[Kushal_Chawda]

can you post sample?

[mayankraoka]

Hi Kushal,

Again back to the old issue.

Attached is the sample qvw.

Please let me know in case of any more information required.

Regards,

Mayank !