Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
kdmarkee
Specialist
Specialist

Difference between functions Min and FirstSortedValue

Hi.  I'm working on a straight table where I want to display only the rows with a minimum time for the day (grouped on day, user and type) which I believe I would do with a calculated dimension, and then have a measure that counts all the rows for that day (again grouped on day, user and type).  These specs are vague, I realize, but as I'm researching ways to do this, I am reading about Min, FirstSortedValue, and even Rank functions and I'm trying to understand when to use which function as there seems to be some similarity in them.  So my real reason for writing today is....Does anyone have a simplistic example that would show how these 3 functions are differ using one dataset so I can get a good understanding?  Thanks.

1 Solution
1 Reply