0 Replies Latest reply: Aug 22, 2017 10:36 AM by David Dunn RSS

    Qlik Sense - Top 10 Table

    David Dunn

      Hi,

       

      I have a top 10 table created, using the limitation dropdown in Qlik Sense. The data set has multiple months worth of data. But I only want to show one line for each user ID.

       

      So in example below I just want to show user ID once and I want Qlik to show the latest period?

       

      User IDPeriodCount
      ABCMar-17100
      DGFJun-1785
      ABCJul-1763
      ZXCJul-1777
      ABCMay-1768
      DGFMar-1735

       

       

      So what I was aiming to get the below, hopefully!

       

      Thanks,

       

      User IDPeriodCount
      ABCJul-1763
      DGFJun-1785
      ZXCJul-1777