topic Re: rank in script in QlikView

rank in script

rajeshqvd — Sat, 16 Nov 2024 05:01:31 GMT

Hello i am getting Count need Rank output thanks advance

avkeep01 — Fri, 07 Dec 2018 13:50:52 GMT

Basically you can start with:

RANK(COUNT(Count))

The next step is using aggregates over color or ID, depending on what you need.
For example:

AGGR(RANK(COUNT(Count)),ID)

But based on the column count you won't get far because all the values are the same per ID.

rajeshqvd — Fri, 07 Dec 2018 14:04:43 GMT

Need to build it in Script Not front end

avkeep01 — Fri, 07 Dec 2018 14:11:26 GMT

Right, no problem.

Sort you table based on your count and then add:

IF(ROWNO()=1,1,PEEK('Rank',-1)+1) AS Rank

It peeks at the previous rows and adds 1 to that number. When sorted at the correct count field you'll get a Rank.

If you want to start a new count for every ID use this:

IF(PEEK('ID',-1)<>ID,1,PEEK('Rank',-1)+1) AS Rank

steax — Tue, 04 Feb 2025 14:30:51 GMT

brilliant thank you 🙂