# Re: \[personal kdb+\] maxima and minima

**URL:** <https://forum.kx.com/t/re-personal-kdb-maxima-and-minima/8129>\
**Category:** Community Support\
**Tags:** kdb-and-q\
**Created:** [January 26, 2013, 8:31pm UTC](https://forum.kx.com/t/re-personal-kdb-maxima-and-minima/8129 "2013-01-26T20:31:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![tavmem1](https://avatars.discourse-cdn.com/v4/letter/t/e68b1a/32.png) [@tavmem1](https://forum.kx.com/u/tavmem1)\
**Post date:** [January 26, 2013, 8:31pm UTC](https://forum.kx.com/t/re-personal-kdb-maxima-and-minima/8129/1 "2013-01-26T20:31:00Z")

</div>

There are built-in functions “max” and “min”.

Sent from my iPhone

---

<div class="post-metadata">

**Author:** ![TerryLynch1](https://avatars.discourse-cdn.com/v4/letter/t/9e8a1a/32.png) [@TerryLynch1](https://forum.kx.com/u/TerryLynch1)\
**Post date:** [January 26, 2013, 9:36pm UTC](https://forum.kx.com/t/re-personal-kdb-maxima-and-minima/8129/2 "2013-01-26T21:36:00Z")

</div>

This should also achieve what you want

q)a!(a\>min a)-a5 | 0  
6 | 0  
7 | 0  
12| 1  
4 | -1  
5 | 0  
7 | 0  
6 | 0  
5 | 0  
4 | -1  
5 | 0

---

<div class="post-metadata">

**Author:** ![Sean11](https://avatars.discourse-cdn.com/v4/letter/s/54ee81/32.png) [@Sean11](https://forum.kx.com/u/Sean11)\
**Post date:** [January 27, 2013, 4:43am UTC](https://forum.kx.com/t/re-personal-kdb-maxima-and-minima/8129/3 "2013-01-27T04:43:00Z")

</div>

same idea, shorten the code a little bit:

q)a!next(-‘:)(\<’:)a

5 | 0

6 | 0

7 | 0

12| 1

4 | -1

5 | 0

7 | 1

6 | 0

5 | 0

4 | -1

5 |?

---

<div class="post-metadata">

**Author:** ![TerryLynch1](https://avatars.discourse-cdn.com/v4/letter/t/9e8a1a/32.png) [@TerryLynch1](https://forum.kx.com/u/TerryLynch1)\
**Post date:** [January 27, 2013, 5:57pm UTC](https://forum.kx.com/t/re-personal-kdb-maxima-and-minima/8129/4 "2013-01-27T17:57:00Z")

</div>

Yeah, totally misread the original problem :)

What I gave would give you the absolute maxima/minima, but not the relative