urgent help needed with top 10

[amien]

i have this chart:

dimension: date, question

expression : sum({set anaylsis} value}

I'm running QV10 and i need to top 10 hits based on date. So if above chart gives 200 results on the date dimension, i only need to latest 10 dates.

how can i do this?

[er_mohit]

if(rank(total sum(value)<=3),value)

sum({<Date = {">=$(=MonthStart(Max(Date), -10))<=$(=MonthEnd(Max(Date), -1))"}}value)

hope it helps

[calvindk]

In the tab "Dimension Limits" you can limit to TOP X values for a dimension.

[amien]

Dimension  Limits is no option in QV10

Sum(value) will give me the rank on sum(value) .. i'm not interesseted in the rank of sum(value). I'm interessed in the top 5 of max(date)

[#5]

try this

= sum(date={"=Rank(num(date))<=10)"}>}value)

[amien]

almost .. i only need the top 10 dates where sum(value) > 0.

[calvindk · Accepted solution]

If the "Max Number" is available in QV10 presentation tab you could use that and then disallow sort.

[amien]

Pff .. and i was trying with AGGR/RANK .. totally forgot the Max nunber  .. Tnx!