Calculation For Top N

[md_qlikview]

Hi Experts,

Is there any way by which i can get top N entity in the straight table eg. Top 10, and total that is displayed on top of that will be the total of only top 10 and not cumulative total of all.

Thanks in advance

[#2]

Try Dimenssion limits

[md_qlikview]

it gives cumulative total and not total of top n. i want total of only top n.

[vivek_niti]

Deselect the option 'Show others' from dimension limits. This will give you the total only for top values.

[hariprasadqv]

Hi,

Use Dimiension Limits and disable Totals in Expressions so that you get the desired output.\

Find the attachment.

[jagan]

Hi,

Try this Calculated Dimension

=If(Aggr(Rank(SUM(MeasureName), 4, 0), DimensionName) <= 10, DimensionName)

Example:

=If(Aggr(Rank(SUM(Sales), 4, 0), Customer) <= 10, Customer)

Regards,

Jagan.

[timanshu]

Please provide dimensions and expressions in report.