Discussion Board for collaboration on QlikView Scripting.
Hello i am getting Count need Rank output thanks advance
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
View solution in original post
Basically you can start with:
The next step is using aggregates over color or ID, depending on what you need. For example:
But based on the column count you won't get far because all the values are the same per ID.