topic Re: how to write expression in QlikView

how to write expression

kunkumnaveen — Mon, 05 Jun 2017 11:34:03 GMT

Hello,

i am trying to display MAX value from a bar in a text box,what i mean is

in the above chart 1000 is the max value ,so i want to display in a TEXTBOX name and max value which is

Kiran :1000

expression i wrote in text box is = max(sum(value))

i known it is wrong

any one plz what exp do i need use to get max value in a text box

sunny_talwar — Mon, 05 Jun 2017 11:37:23 GMT

Try this

Max(Aggr(Sum(value), name))

kunkumnaveen — Mon, 05 Jun 2017 11:39:37 GMT

i got value ,is there any chance to get name of that value from name field

sunny_talwar — Mon, 05 Jun 2017 11:40:53 GMT

Sure, try this

FirstSortedValue(name, -Aggr(Sum(value), name))

FirstSortedValue(DISTINCTname, -Aggr(Sum(value), name))