Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
salma_salousa
Contributor III
Contributor III

Max of Multiple fields in a table

Hi,


I am trying to get the maximum values for multiple fields is a table and display it in KPI.


for example : I have fields F1, F2, F3


F1 has values--> 1,3,4

F2 has values--> 1,2,3

F3 has values--> 2,3,4


so in this case KPI would show the maximum total of the 3 fields which is 9


can anyone please help.


Thank you.

1 Solution

Accepted Solutions
maxgro
MVP
MVP

rangemax(sum(F1),sum(F2),sum(F3))

View solution in original post

9 Replies
sunny_talwar

May be this

Sum(RangeMax(F1, F2, F3))

its_anandrjs

How it should be 9 can you explain this please for understanding. Will it be maximum values for all three fields that is (3+3+3).

salma_salousa
Contributor III
Contributor III
Author

F1=1+2+4

F2=1+2+3

F3=2+3+4

the sum of F3 is the maximum this is what I want to show

sunny_talwar

May be this

RangeMax(Sum(F1), Sum(F2), Sum(F3))

maxgro
MVP
MVP

rangemax(sum(F1),sum(F2),sum(F3))

View solution in original post

its_anandrjs

Where you want to use this expression.

salma_salousa
Contributor III
Contributor III
Author

Thank a lot this worked

salma_salousa
Contributor III
Contributor III
Author

Thanks a lot this worked

its_anandrjs

They are individual fields then try only this expression in any text object or the KPI object

=RangeMax(Sum(F1), Sum(F2), Sum(F3))


Or


=Sum(RangeMax(F1, F2, F3))