Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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