topic Re: Rank() in QlikView

Rank()

prajapatiamar38 — Fri, 10 Jul 2015 09:02:09 GMT

Hi Experts,

How to give a rank on expression without considering any diamensions in straight table?

no affect of diamension on rank function

Plz help me...
Thanks.

Re: Rank()

Gysbert_Wassenaar — Fri, 10 Jul 2015 09:33:52 GMT

The rank of something outside the context of a dimension will always be 1.

Re: Rank()

swuehl — Fri, 10 Jul 2015 09:36:16 GMT

What is the expression you are using?

And what do you expect to get when using a rank?

Re: Rank()

prajapatiamar38 — Fri, 10 Jul 2015 09:37:52 GMT

hi...,
thanks for your reply.

according to my scenario..
is it possible in straight table or not?

Re: Rank()

prajapatiamar38 — Fri, 10 Jul 2015 09:42:12 GMT

hie..

m using three dimension...(city,place,name)
one calculated expresion...(sum(score))
and i want rank on sum(score) but without considering dimensions...
but the dimension should be there in staright table..

is it possible or not?

Re: Rank()

swuehl — Fri, 10 Jul 2015 09:48:55 GMT

Ok, but what do you expect to see then? A rank based on what differentiation, if not considering the dimensions?

As Gysbert said, you will get a constant rank for all lines, so what's the benefit of ranking then?

Re: Rank()

prajapatiamar38 — Fri, 10 Jul 2015 09:57:58 GMT

hie...
its my requirement......

as u said its give rank 1 for all...

City	Place	Name	Score
Mumbai	ddd	Prakash	56
Pune	hghg	Anand	56
Pune	rr	Raj	56
Mumbai	AAA	Vijay	55
Pune	tty	Akshata	45
Pune	fffg	Suraj	44
Pune	rr	Vijaya	43
Pune	ygfh	Leena	34
Mumbai	AAA	Pooja	30
Mumbai	Vileparle	Anil	10

i want rank lyk....

56 1

55 2

45 3

44 4

43 34

Re: Rank()

swuehl — Fri, 10 Jul 2015 10:00:47 GMT

Maybe you want

=Rank(TOTAL sum(Score))

Re: Rank()

Gysbert_Wassenaar — Fri, 10 Jul 2015 10:01:31 GMT

Try =rank(sum(score),1)

Re: Rank()

prajapatiamar38 — Fri, 10 Jul 2015 10:03:02 GMT

hie...
its my requirement......

as u said its give rank 1 for all...

City	Place	Name	Score
Mumbai	ddd	Prakash	56
Pune	hghg	Anand	56
Pune	rr	Raj	56
Mumbai	AAA	Vijay	55
Pune	tty	Akshata	45
Pune	fffg	Suraj	44
Pune	rr	Vijaya	43
Pune	ygfh	Leena	34
Mumbai	AAA	Pooja	30
Mumbai	Vileparle	Anil	10

i want rank lyk....

56 1

55 2

45 3

44 4

43 5

30 6

10 7

and main thing is that i want to use this cocept in adhoc report..

so diamension selection may random..
some time 1 diamension selected and some time 3 or 2 also...

Rank()

Re: Rank()

Kushal_Chawda — Fri, 10 Jul 2015 10:34:24 GMT

Create Rank from script

New:

LOAD * Inline [

City, Place, Name, Score

Mumbai, ddd, Prakash, 56

Pune, hghg, Anand, 56

Pune, rr, Raj, 56

Mumbai, AAA, Vijay, 55

Pune, tty, Akshata, 45

Pune, fffg, Suraj, 44

Pune, rr, Vijaya, 43

Pune, ygfh, Leena, 34

Mumbai, AAA, Pooja, 30

Mumbai ,Vileparle, Anil, 10 ];

Data:

NoConcatenate

LOAD City, Place, Name,

sum(Score) as Score,

autonumber(sum(Score)) as Rank

Resident New

Group by City, Place, Name;

DROP Table New;