Discussion Board for collaboration related to Creating Analytics for QlikView.
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
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
Go to Solution.
Sure, try this
FirstSortedValue(name, -Aggr(Sum(value), name))
FirstSortedValue(DISTINCTname, -Aggr(Sum(value), name))
i got value ,is there any chance to get name of that value from name field