Select Maximum value in taxt box

[swiftfahad]

Hi,

I am having a follwing table 

customerId	Band	date	capacity
1	KU	22-Feb-22	1900
1	CU	22-Feb-22	1000
1	KU	13-Jan-22	2500
1	CU	13-Jan-22	1200
2	KU	13-Jan-22	1300
2	CU	13-Jan-22	800
2	KU	22-Feb-22	3000
2	CU	22-Feb-22	3500

I have two text boxt to show maximum capacity value base on data  i.e ( one box for KU-capacity and other for CU-capacity)

if user select customer one 

Ku-capcity text box must show : 1900 

cu-capcity box must show:  1000

because these are the values lie angainst 22/feb/2022 which is maximum or highest.

need expression for text box

i  m using

=sum({<date={'$(Max(date))'}>}capacity) but no result

[abhijitnalekar · Accepted solution]

Hi @swiftfahad

I hope you are looking at the result as below.

 

Please create one variable to set the max date as below

test as date(aggr(max(dated),customerId),'DD-MMM-YY')

and use below expression in the text to show CU value

sum({<dated={"$(test)"},Band={'CU'}>}capacity)

and do the use below for KU

sum({<dated={"$(test)"},Band={'KU'}>}capacity)

[MarcoWedel]

FirstSortedValue({$<Band={'KU'}>} capacity,-date)

[Akeem]

---

@MyAARPMedicare Login wrote:

Hi,

I am having a follwing table 

customerId	Band	date	capacity
1	KU	22-Feb-22	1900
1	CU	22-Feb-22	1000
1	KU	13-Jan-22	2500
1	CU	13-Jan-22	1200
2	KU	13-Jan-22	1300
2	CU	13-Jan-22	800
2	KU	22-Feb-22	3000
2	CU	22-Feb-22	3500

I have two text boxt to show maximum capacity value base on data  i.e ( one box for KU-capacity and other for CU-capacity)

if user select customer one 

Ku-capcity text box must show : 1900 

cu-capcity box must show:  1000

because these are the values lie angainst 22/feb/2022 which is maximum or highest.

need expression for text box

i  m using

=sum({<date={'$(Max(date))'}>}capacity) but no result

---

So if the user types in a number more than 100 then it will automatically change the value to 100 using a keyup() function and if user types in a number less than 0 it will display as 0?