topic Re: first 5 value in QlikView

first 5 value

renjithpl — Fri, 14 Dec 2012 18:34:48 GMT

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 — Fri, 14 Dec 2012 18:40:36 GMT

Use dimension limit or rank() function

Hope it helps

danielrozental — Fri, 14 Dec 2012 18:40:48 GMT

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 — Fri, 14 Dec 2012 18:48:21 GMT

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

Fri, 14 Dec 2012 18:54:58 GMT

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 — Fri, 14 Dec 2012 19:00:15 GMT

Im not looking the sum just the first maximum sorted value

Fri, 14 Dec 2012 19:09:11 GMT

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

Regards,

-Khaled.

CELAMBARASAN — Fri, 14 Dec 2012 19:40:55 GMT

Check the attached

this is what your expected?