Selecting Ascending 5 Values in expression

[#1]

HI Experts

In my Pivot table, Using a calculated Field Difference

Difference = ([last month Sales] - [Current month Sales])

now i want to choose on top 5 values by Ascending order

Please Suggest

[#2]

HI QLIKmsg4u

Please find the attached QVW

there are 21 customers

sort is based on the field Difference Ascending

Now in this Straight table i want to show top 5 values for the field Difference

[#3]

HI Avinash

Please find the attached QVW

there are 21 customers

sort is based on the field Difference Ascending

Now in this Straight table i want to show top 5 values for the field Difference

[#4]

HI Vijeta

How can i do that for expressions in Dimension Limit

Sorry i am not clear

[krishna20]

Hi,Try like this

Right click on straight table-> choose properties-> under properties Select Dimension Limits.Enable Restrict option .

Show only 5 or 10..what ever you need.

[#6]

HI Krishna20

My Field Difference is an Calculated Expression not a dimension

[krishna20]

Hi,

The below thread may clears your requirement.

Rank function in expression

[krishna20]

Hi,

Please find the below attachment. Is this the your expected output?