Discussion Board for collaboration related to Creating Analytics for QlikView.
I'm trying to calculate a rank from the Rating column that is aggregated over Date, Time and Location fields.
This is my current table where Rank = rank(TOTAL(Rating),0,1)
What I need to achieve is:
I've tried using rank and aggr but just cannot get it to work.
Any help appreciated.
View solution in original post
rank(TOTAL <Date> only(Rating),0,1)
maybe remove Total from Expression
Thanks, but that returns Rank as 1 for all rows,
Thanks, that worked