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 ID | Period | Count |
---|
ABC | Mar-17 | 100 |
DGF | Jun-17 | 85 |
ABC | Jul-17 | 63 |
ZXC | Jul-17 | 77 |
ABC | May-17 | 68 |
DGF | Mar-17 | 35 |
So what I was aiming to get the below, hopefully!
Thanks,
User ID | Period | Count |
---|
ABC | Jul-17 | 63 |
DGF | Jun-17 | 85 |
ZXC | Jul-17 | 77 |
| | |