topic Re: Adding place numbers in scrip in QlikView

Adding place numbers in scrip

sculptorlv — Tue, 25 Sep 2018 12:17:52 GMT

Hello!

I have the following code:

SORTED_MANAGERS:

LOAD

Employee,

Points,

RESIDENT FINAL_POINTS

ORDER BY

Employee,

Points DESC

;

How can I modify this LOAD statement in order to get an extra column NPK with number 1,2,3 and so forth for Employees with better Points result?

NPK Employee Points

1 Janis 54

2 Jonh 47

3 Sara 34

.....

Thank you in advance!

Re: Adding place numbers in scrip

sasiparupudi1 — Tue, 25 Sep 2018 12:21:25 GMT

LOAD

RecNo() as NPK,

Employee,

Points,

RESIDENT FINAL_POINTS

ORDER BY

Employee,

Points DESC

;

Re: Adding place numbers in scrip

sculptorlv — Tue, 25 Sep 2018 12:27:42 GMT

I guess it gives number for none sorted values :

Re: Adding place numbers in scrip

stigchel — Tue, 25 Sep 2018 12:31:06 GMT

Something like this?

FINAL_POINTS:

Load * Inline [Employee,Points

Jonh,47

Sara,64

Janis,54

];

SORTED_MANAGERS:

Load Rowno() as NPK,*;

LOAD

Employee,

Points

RESIDENT FINAL_POINTS

ORDER BY Points DESC

;

DROP Table FINAL_POINTS;

Re: Adding place numbers in scrip

sculptorlv — Tue, 25 Sep 2018 12:33:16 GMT

I needed to change the sequence of Ordered columns.

Thank you for help!!

LOAD

RecNo() as NPK,

Employee,

Points,

RESIDENT FINAL_POINTS

ORDER BY

Points DESC,

Employee

;