Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

paisleymike
New Contributor III

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

11 Replies
dberkesacn
Contributor III

Re: Show highest value through Expression

arvind_patil
Valued Contributor II

Re: Show highest value through Expression

Hi Michael,

Try this:

Max(Fieldname)

Thanks,

Arvind Patil

paisleymike
New Contributor III

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

dberkesacn
Contributor III

Re: Show highest value through Expression

then RangeMax()  function?

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

if no could you share the example?

paisleymike
New Contributor III

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    

MVP
MVP

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

dberkesacn
Contributor III

Re: Show highest value through Expression

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

RangeSum.jpg

paisleymike
New Contributor III

Re: Show highest value through Expression

That worked

Its now shows the max figure

Thank you

dberkesacn
Contributor III

Re: Show highest value through Expression

please mark helpful the answer.

Thanks.

Daniel