topic Difference between functions Min and FirstSortedValue in QlikView https://community.qlik.com/t5/QlikView/Difference-between-functions-Min-and-FirstSortedValue/m-p/1257078#M397091 <HTML><HEAD></HEAD><BODY><P>Hi.&nbsp; 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).&nbsp; 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.&nbsp; 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?&nbsp; Thanks.</P></BODY></HTML> Sun, 12 Feb 2017 17:47:50 GMT kdmarkee 2017-02-12T17:47:50Z Difference between functions Min and FirstSortedValue https://community.qlik.com/t5/QlikView/Difference-between-functions-Min-and-FirstSortedValue/m-p/1257078#M397091 <HTML><HEAD></HEAD><BODY><P>Hi.&nbsp; 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).&nbsp; 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.&nbsp; 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?&nbsp; Thanks.</P></BODY></HTML> Sun, 12 Feb 2017 17:47:50 GMT https://community.qlik.com/t5/QlikView/Difference-between-functions-Min-and-FirstSortedValue/m-p/1257078#M397091 kdmarkee 2017-02-12T17:47:50Z Re: Difference between functions Min and FirstSortedValue https://community.qlik.com/t5/QlikView/Difference-between-functions-Min-and-FirstSortedValue/m-p/1257079#M397092 <HTML><HEAD></HEAD><BODY><P>The Help <A href="https://help.qlik.com/en-US/qlikview/12.1/Content/Home.htm" title="https://help.qlik.com/en-US/qlikview/12.1/Content/Home.htm">https://help.qlik.com/en-US/qlikview/12.1/Content/Home.htm</A> is good for function definitions.</P><P></P><P>See:</P><P></P><P><A href="https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/BasicAggregationFunctions/min.htm" title="https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/BasicAggregationFunctions/min.htm">https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/BasicAggregationFunctions/min.htm</A></P><P></P><P><A href="https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/BasicAggregationFunctions/firstsortedvalue.htm" style="font-size: 10pt;" title="https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/BasicAggregationFunctions/firstsortedvalue.htm">https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/BasicAggregationFunctions/firstsorted…</A></P><P></P><P><A href="https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/RankingFunctions/rank.htm" title="https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/RankingFunctions/rank.htm">https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/RankingFunctions/rank.htm</A></P></BODY></HTML> Sun, 12 Feb 2017 18:16:41 GMT https://community.qlik.com/t5/QlikView/Difference-between-functions-Min-and-FirstSortedValue/m-p/1257079#M397092 Anonymous 2017-02-12T18:16:41Z