topic Re: in multiple selection find max value in QlikView

in multiple selection find max value

manoj217 — Wed, 25 Nov 2020 16:16:04 GMT

i have a year list box and i selected 2010 ,2011 ,2012 by led check boxes i want find the max of year in my current selection

Re: in multiple selection find max value

Anil_Babu_Samineni — Thu, 12 Oct 2017 10:07:08 GMT

Where you want to show Maximum ?

Re: in multiple selection find max value

swuehl — Thu, 12 Oct 2017 10:09:24 GMT

=Max(YearField)

Re: in multiple selection find max value

arvind_patil — Thu, 12 Oct 2017 10:11:22 GMT

Hi Manoj,

If All field values you had selected in single filed then simply use.

Max(Year)

Thanks,

Arvind Patil

Re: in multiple selection find max value

manoj217 — Thu, 12 Oct 2017 10:14:12 GMT

it will show only the highest year in the year field but i want highest year in my current selections. in Year list box i have taken led check box so i can select multiple years . now i want to find the max year in my selection.

Re: in multiple selection find max value

manoj217 — Thu, 12 Oct 2017 10:17:00 GMT

i have 1 to 10 yrs in list box, but i selected 1 ,4, 6, 7 by multiple selection now i want to show the max value of my selections (7)

Re: in multiple selection find max value

devarasu07 — Thu, 12 Oct 2017 10:23:06 GMT

Hi,

Can you try like this?

Max({1}Year)

Re: in multiple selection find max value

manoj217 — Thu, 12 Oct 2017 10:24:48 GMT

i have selected 2014 so it will shows 2014 but if i select 2014 and 2015 it will shows '-' so plz suggest

Re: in multiple selection find max value

Anil_Babu_Samineni — Thu, 12 Oct 2017 10:29:50 GMT

Don't require anything here, Use Max(Year) and select 2/3 then check how Text box returns, And for your condition you may need this

=If(GetFieldSelections(Year) = Max(TOTAL Year), Year)

Re: in multiple selection find max value

swuehl — Thu, 12 Oct 2017 10:30:48 GMT

Max(YearField) should show you what you want, the highest value in your selection.

You may use GetSelectedCount( YearField ) to check if something has been selected at all, to handle all values being possible, not selected.

=If(GetSelectedCount( YearField ), Max(YearField ))

Re: in multiple selection find max value

devarasu07 — Thu, 12 Oct 2017 10:38:01 GMT

Hi,

=if(GetSelectedCount(Year)<>0,Max(Year))

Re: in multiple selection find max value

MarcoWedel — Wed, 25 Oct 2017 19:30:56 GMT

Hi,

Please review your open threads and close those who received correct answers:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco