3 Replies Latest reply: Mar 29, 2018 10:47 AM by Sunny Talwar RSS

    Get the top rank retailer

    Wanyun Yang

      Hi guys,

       

      I want to get the top rank retailer in QLIK SENSE. My function is: IF(AGGR(RANK(SUM(orderTotal)),Retailer)=1,Retailer). But it shows nothing. How should I modify my function?

       

      Thanks for help!