topic Select Maximum value in taxt box in QlikView

Select Maximum value in taxt box

swiftfahad — Wed, 23 Feb 2022 08:28:07 GMT

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

Re: Select Maximum value in taxt box

abhijitnalekar — Wed, 23 Feb 2022 11:26:18 GMT

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)

Re: Select Maximum value in taxt box

MarcoWedel — Wed, 23 Feb 2022 19:34:03 GMT

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

Re: Select Maximum value in taxt box

Akeem — Mon, 28 Feb 2022 05:08:07 GMT

@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?