Discussion board where members can get started with QlikView.
I have Four fields,say
thanks in advance.
Go to Solution.
Aggr(If(Rank(Max(Hours))<3,Max(Hours)), Year, Project)
View solution in original post
Try like this:
For year 2018 i am getting different out put check the sample.
I missed the max part
instead of sum ,if we use max it will give proper output
Thank you Tresesco