6 Replies Latest reply: Mar 1, 2017 4:44 AM by Sunny Talwar RSS

    Rank in set analysis

    Anjali Ahlawat

      Hi experts,


      I am using the below expression in qlikview but < is not giving me correct results,

      how can i achieve the less than equal to value without any errors.


      =aggr(sum({<Rank = {"<= $(=aggr((round(count(HostName)/2) - count({<UpTime = {'1'}>}HostName)),Hrs)+1) >1"}>}UpTime),Hrs)


      Thanks in advance.