Need Help for finding the ranks of the student in ... - Qlik Community

Report Inappropriate Content · ‎2013-04-23

hi friends i am usnig STUDENT NO,MARKSOUT50 fields i a table

iwany the result in table box as STUDENTO,MARKSOUT50,RANK

likewise shown in the attachement by using script i want the result

Please help me..........

kaushiknsolanki · ‎2013-04-24

Hi,

Create a straight table with dimension as student.

Expression as Sum(Mark)

Expression as Rank(Sum(Mark))

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

vikasmahajan · ‎2013-04-24

rank( sum( Sales ), 0, 1 )

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

jagan · ‎2013-04-24

Hi Srikanth,

Try like this, if you want to calculate rank in script

StudentTemp:

LOAD student,

marksoutof50

FROM

work.xlsx

(ooxml, embedded labels, table is Sheet1);

Student:

LOAD

*,

RowNo() AS Rank

RESIDENT StudentTemp

ORDER BY marksoutof50 DESC;

DROP TABLE StudentTemp;

Hope this helps you.

Regards,

Jagan.

Need Help for finding the ranks of the student in student table