Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

how to write expression

Hello,

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

Untitled.png

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

1 Solution

Accepted Solutions
MVP
MVP

Re: how to write expression

Sure, try this

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

or

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

3 Replies
MVP
MVP

Re: how to write expression

Try this

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

kunkumnaveen
Contributor III

Re: how to write expression

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

MVP
MVP

Re: how to write expression

Sure, try this

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

or

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

Community Browser