topic Re: urgent help needed with top 10 in QlikView

urgent help needed with top 10

amien — Mon, 06 May 2013 12:29:52 GMT

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 — Mon, 06 May 2013 12:39:16 GMT

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

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

hope it helps

calvindk — Mon, 06 May 2013 12:39:57 GMT

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

amien — Mon, 06 May 2013 12:41:00 GMT

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)

Mon, 06 May 2013 12:44:27 GMT

try this

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

amien — Mon, 06 May 2013 12:57:37 GMT

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

calvindk — Mon, 06 May 2013 13:22:31 GMT

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

amien — Mon, 06 May 2013 13:27:34 GMT

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