topic TOP N in QlikView

TOP N

emteam162 — Wed, 26 Dec 2012 14:03:50 GMT

Hi All,

I want compare top N sales by year, in my dimension i put Month and in my expression i have this :

Sum({<Sales={"=

rank(

sum({<year={'$(vMaxYear)'} >}number)

)<N"},

year=,month=,

year={'$(vMaxYea)'},

>} number)

but when i check (i created straight table with all sales store by expression desc and select year and month ) i don't have same result

Please, Any idea ???

Many thanks

Emteam

Re: TOP N

emteam162 — Wed, 26 Dec 2012 15:56:27 GMT

Hi,

Any IDEAS????

Regards,

Emteam

Re: TOP N

Wed, 26 Dec 2012 19:41:47 GMT

Hi Emteam,

I did not understand your expression,.but you can get the top n records by creating a variable and use that variable in slider object..The process is 1.create variable.2.create slider object 3. In the slider object propertes ,In the general tab in the data option in place of selecting field ,select the variables option, in that select the variable you have created and adjust the scale according to your requirement

hope it helps

you

regards ramesh

Re: TOP N

emteam162 — Thu, 27 Dec 2012 01:56:27 GMT

Hi rameshmca,

thanks for your answer.

I explain what i want : i will create line chart to have only top 10 costumer

in my dimension i have Month and im my expression i have this

Sum({<CostumerID={"=

rank( sum({<year={'$(vMaxYear)'} >}amount),costumerID)<Top10"},

year={'$(vMaxYea)'},

>} amount)

i have this

Month	2012	2011
TOTAL	4 429	8 998
Janv	638	7430
Fev	891	994
Mars	156	166
Avril	1 499	167
May	1 245	241
Juin	0	0

but when i make selection in month for exemple i select Jan i have this result

Month	2012	2011
	738	8 430
Janv	738	8430

Is not same result i have in the first table

May be my expression is false i can't explain difference the result

if you have any idea ?

Many thanks

Emteam

Re: TOP N

emteam162 — Thu, 27 Dec 2012 16:21:03 GMT

Please, Any idea ???