11 Replies Latest reply: Oct 13, 2017 12:16 AM by ishan Bhatt

Show highest value through Expression

Hello

I have found the percentages of certain values which I'm interested in

But I'm looking for an expressions to show the highest percentage based on a certain value in a KPI

i.e.

A = 10%

B = 20%

C = 5%

Show percentage of B

• Re: Show highest value through Expression

Have you tried the max function ?

=num(max( Value),'0.0%')

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/AggregationFunctions/max.htm

Daniel

• Re: Show highest value through Expression

Hi Michael,

Try this:

Max(Fieldname)

Thanks,

Arvind Patil

• Re: Show highest value through Expression

Hello

Forgot to say that the values are in created in different measures

They are not in the dataset

• Re: Show highest value through Expression

then RangeMax()  function?

=RangeMax(sum(Value1),sum(Value2))

if no could you share the example?

• Re: Show highest value through Expression

Hello

I have 3 measures A,B,C

I am looking for a way to show the Max of these three measures

I've tried to enter the code for each measure into a Max() but it does not accept nested aggregation

If there is a way around that it would be appreciated

• Re: Show highest value through Expression

at the top you can see an example representing rangesum, bottom you can check the simple data model.

• Re: Show highest value through Expression

That worked

Its now shows the max figure

Thank you

• Re: Show highest value through Expression

Thanks.

Daniel

• Re: Show highest value through Expression

May be like this

FirstSortedValue(FieldName, -Aggr(YourExpressionHere, FieldName))

Here fieldname is the field which would would include A, B, or C and YourExpressionHere is the expression you used for your table

• Re: Show highest value through Expression

Can you express this better?

• Re: Show highest value through Expression

Hello Michael,

Use below expression

=FirstSortedValue([Alphabet],-aggr(Max([Percentage]),[Alphabet]),1)

Please note that here I've given Alphabet and percentage field name of your data.