Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Partner - Creator III
Partner - Creator III

arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Michael,

Try this:

Max(Fieldname)

Thanks,

Arvind Patil

Anonymous
Not applicable
Author

Hello

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

They are not in the dataset

dberkesacn
Partner - Creator III
Partner - Creator III

then RangeMax()  function?

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

if no could you share the example?

Anonymous
Not applicable
Author

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    

sunny_talwar

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
Partner - Creator III
Partner - Creator III

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

RangeSum.jpg

Anonymous
Not applicable
Author

That worked

Its now shows the max figure

Thank you

dberkesacn
Partner - Creator III
Partner - Creator III

please mark helpful the answer.

Thanks.

Daniel