Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik Sense - Top 10 Table

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
0 Replies