Discussion Board for collaboration related to QlikView App Development.
I have a straight table containing dimensions,
Year , Week Number , Day name
2016 , 1 , Mon
2016 , 2 , Tue
2016 , 2 , Wed
2015 , 1 ,Mon
2015 , 3 , Tue
I have attached the sample data. I would like to rank those rows group by Year. Like below
Year , Week Number , Day name , Rank
2016 , 1 , Mon , 1
2016 , 2 , Tue , 2
2016 , 2 , Wed , 3
2015 , 1 ,Mon , 1
2015 , 3 , Tue , 2
Ranking should restart with new year. Please help.
A script based solution could be:
(biff, embedded labels, table is Sheet1$, filters(
Remove(Row, Pos(Top, 2))
AutoNumber(SAT_FISCAL_WEEK_NUMBER & '|' &DAY_NAME,Year) as RankNo
Resident Data Order by SAT_FISCAL_WEEK_NUMBER,DAY_NAME;
DROP Table Data;
If what Andrew or vishsaggi provided doesn't work for you, would you be able to elaborate on what exactly is needed? I feel I am not really sure what is needed here.