topic Re: Max and Min function on character/string data ? in QlikView

Max and Min function on character/string data ?

HWallays — Sat, 16 Nov 2024 01:37:15 GMT

Is there a function that will allow me to select the min or max of a string value ? Have the impression it only works with numerical data but does not work with strings ( in sql I use it regularely for strings too)…

When applying the min or max on strings it returns blanks 😉

Re: Max and Min function on character/string data ?

kaushiknsolanki — Mon, 30 Dec 2019 10:19:36 GMT

Hi,

Try MinString and MaxString functions.

Regards,

Kaushik Solanki

Re: Max and Min function on character/string data ?

Anil_Babu_Samineni — Mon, 30 Dec 2019 10:50:37 GMT

How is the string looks like? Can you post few rows for us

Re: Max and Min function on character/string data ?

HWallays — Mon, 30 Dec 2019 10:55:40 GMT

thank you kaushiknsolanki.

I was not aware there were actually specific minstring and maxstring functions. Indeed they work perfectly !