first 5 value

[renjithpl]

Hi all

I want to show top 5 highest value but not the sum in a straight table, I can't use sum it aggregates everything

Regards

Then

[MayilVahanan]

HI

Use dimension limit or rank() function

Hope it helps

[danielrozental]

If you're using QV11 you can just limit the dimension, if you're using QV10 you can limit the number of rows that are shown, then sort by the value.

[renjithpl]

Im using qv 11 but I don't want to show sum just top maximum 5 values

Table

Id  value

A.  300

A.  200

A.  100

If I sum I get

A.  600

I want like above

[#5]

Hi,

To Show the Top (Highest)  5 values, go to the properties of the Straight Table.

Under Dimension Limits tab, select your Dimension and mark the check box for "Restrict which values are displayed...."
and set 'Show Only' as 5.

If you are just trying to remove the aggr (total) value displayed on top row, go to the expressions tab,
select the  "No Totals" radio button.

Hope that helps.

Please find attachment.

Regards,

-Khaled.

[renjithpl]

Im not looking the sum just the first maximum sorted value

[#7]

Hi

Have you tried setting the sort value to Numeric-Descending...from the table properties for your dimension?

Regards,

-Khaled.

[CELAMBARASAN · Accepted solution]

Check the attached

this is what your expected?