topic Rank function Qlikview in QlikView https://community.qlik.com/t5/QlikView/Rank-function-Qlikview/m-p/954565#M328149 <HTML><HEAD></HEAD><BODY><P>I have some troubles about ranking . See below picture</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/109408_Capture.PNG" style="height: auto;" /></P><P>expression in Rank column : =VRank( Sum( DETAIL_NET_SALE_VALUE)/sum(ITEM_COUNT_WITH_WEIGHT),0)</P><P>But I would like to rank like "This rank" column.</P><P>More over, How can I hide thoundsand without changing it?</P><P>For example, 123 500 200 233 -&gt; 123 500 200</P><P>Because on browser, we want to show our numbers without thounsand but exporting excel file will show full of number.</P></BODY></HTML> Fri, 18 Dec 2015 09:10:46 GMT 2015-12-18T09:10:46Z Rank function Qlikview https://community.qlik.com/t5/QlikView/Rank-function-Qlikview/m-p/954565#M328149 <HTML><HEAD></HEAD><BODY><P>I have some troubles about ranking . See below picture</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/109408_Capture.PNG" style="height: auto;" /></P><P>expression in Rank column : =VRank( Sum( DETAIL_NET_SALE_VALUE)/sum(ITEM_COUNT_WITH_WEIGHT),0)</P><P>But I would like to rank like "This rank" column.</P><P>More over, How can I hide thoundsand without changing it?</P><P>For example, 123 500 200 233 -&gt; 123 500 200</P><P>Because on browser, we want to show our numbers without thounsand but exporting excel file will show full of number.</P></BODY></HTML> Fri, 18 Dec 2015 09:10:46 GMT https://community.qlik.com/t5/QlikView/Rank-function-Qlikview/m-p/954565#M328149 2015-12-18T09:10:46Z