23 Replies Latest reply: Mar 6, 2018 8:22 AM by Kizzy Davies RSS

    Cannot get AGGR expression to work

    Kizzy Davies

      Hi,

       

      I asked a previous question on how to create a bar chart that displays 1 value but is filtered by another.

       

      An expression was given (see below)

      =if( RANK( Sum({$<[Requisition Status]={Closed}>}[Number of Filled Reqs]) )<=5,Sum({$<[Division]={'Lifestyle Audio'}>}[Approve to Close])/Sum({$<[Division]={'Lifestyle Audio'}>}[Number of Filled Reqs]))

       

      The expression works but shows the countries that are not are not in the top 5.  I then got this instruction but I cannot get it to work

       

      =AGGR(if(RANK(SUM(Sales))<=4,Country),Country) and then check suppress null values

       

      QLIK Rank screen shot.PNG

       


      Please help.Thanks,Kizzy