15 Replies Latest reply: Aug 22, 2018 10:00 AM by Andrea Gigliotti RSS

    Top 10 in straight table Qliksense

    Anupama Jagan

      Hi All,

       

      Requirement is to restrict the last 10 customers based on issueddate. Need to restrict the customer data based on dates for the below table. I'm not able to restrict it in Qliksense. Kindly let me know how to proceed:

      Dimensions are :

      Customer ID

      Customer Name

      IssuedDate

      Expression:

      Premium

       

         

      Customer IDCustomer NameIssuedDatePremium
      1ABC8/8/2018100
      2EFG8/9/2018200
      3CFG8/10/2018300
      4ADF8/11/20183576
      5JAF8/12/20182890
      6QSD8/13/20182647
      7ABC8/14/20184557
      8ERT8/15/20189089
      9WSC8/16/2018784
      10SDF8/17/20183546
      11ABC8/18/20181678
      12QSD8/22/20181678
      13QWR8/22/2018345
      14RDF8/22/2018574
      15GHH8/22/2018678

       

       

       

      Expected result from QS is to show only this 10 customers

       

         

      Customer IDCustomer NameIssuedDatePremium
      12QSD8/22/20181678
      13QWR8/22/2018345
      14RDF8/22/2018574
      15GHH8/22/2018678
      11ABC8/18/20181678
      10SDF8/17/20183546
      9WSC8/16/2018784
      8ERT8/15/20189089
      7ABC8/14/20184557
      6QSD8/13/20182647

       

       

      Thanks in advance,

      Anupama Jagan