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.