how to show Rank of Negative and Positive Field values

[#1]

Hi All,

Can any one please guide me how to show rank of positive and negative values in qlikview.

Thanks

Deepak

[sunny_talwar]

Well how would you want to rank them? I think the best way would be to provide a sample with your expectation of what you want to see:

QlikCommunity Tip: How to get answers to your post?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

[Saravanan_Desingh]

Irrespective of Sign, the Rank function will designate the Rank.

F1	Rank(F1)
	-
100	1
-87	5
1	3
24	2
-5	4

[swuehl]

And if you use

Rank( -F1 )

you would rank your values with the most negative values at top.