Rank function Qlikview

[#1]

I have some troubles about ranking . See below picture

expression in Rank column : =VRank( Sum( DETAIL_NET_SALE_VALUE)/sum(ITEM_COUNT_WITH_WEIGHT),0)

But I would like to rank like "This rank" column.

More over, How can I hide thoundsand without changing it?

For example, 123 500 200 233 -> 123 500 200

Because on browser, we want to show our numbers without thounsand but exporting excel file will show full of number.