Discussion Board for collaboration on QlikView Scripting.
I am having a problem with ranking data as per my needs.
I tried in SQL directly and with use of QV functions.
I want to achieve rank as per below example
1. Rank should reset for next employee (row 5)
2. When Type is the same continuously, week by week, Rank stays the same. (rows 1 & 2)
2. When Type changes, rank changes as well (row 3)
3. When same Employee and Type combination is occurring again, but not as continuation, Rank must change (row 2 & 4, as was divided by different type in row 3
How to achieve that?
Go to Solution.
if(Previous(Employee)=Employee,if(Previous(Type)=Type,peek(Rank),rangesum(1,peek(Rank))),1) as Rank
Please see the attached file
Big thanks to both of you! Both solutions are correct Marking Gysbert's one as correct as he was faster.
Yeah gwassenaar is the champ.