Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-12-18 04:10 AM

Rank function Qlikview

I have some troubles about ranking . See below picture

Capture.PNG

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.

558 Views
0 Likes
0 Replies