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: 
sibusiso90
Creator III
Creator III

Compare different fields

Hi All

I am trying to get the max of the totals of four columns in QlikView,

E.G

 

Sales1Sales2Sales3Sales4Sales5
9953193757029503087954179653910456
242959563429512114175090773608470
75027771084741822589992747342880707
41708688277166838553112084888889074
5574505987442725904093130064703888
86759138754941446622957427972076824
6190032332646212051432177296595792
2995885774748554717339729133414509
4471064283329269263450432331522726
31092277931019216575778778098894882
56304473280298831273043840291883162
243949863272569170954318443587639
4698143955418726625831105999362451968129

The last row is the total for the different sales and I want a way to pull the sales 3 as it has the largest Total.
I also want to get the max value out of the five sales.

My Results should be

Sales

62583110

1 Solution

Accepted Solutions
tresesco
MVP
MVP

To get name of the field you could try like:

= 'Max of totals is in field : ' &

RangeMaxString( Dual('Sales1' , Sum(Sales1)), Dual('Sales2' , Sum(Sales2)), Dual('Sales3' , Sum(Sales3)), Dual('Sales4' , Sum(Sales4)), Dual('Sales5' , Sum(Sales5)) )

& ' and the value is : '

RangeMax( Sum(Sales1),Sum(Sales2),Sum(Sales3),Sum(Sales4),Sum(Sales5) )

View solution in original post

7 Replies
tresesco
MVP
MVP

For max of totals = RangeMax( Sum(Sales1),Sum(Sales2),Sum(Sales3),Sum(Sales4),Sum(Sales5) )

For max of all = RangeMax( Max(Sales1),Max(Sales2),Max(Sales3),Max(Sales4),Max(Sales5) )

madhumitha
Creator
Creator

Hi,

you can use

=NumMax([Sales1],[Sales2],[Sales3],[Sales4],[Sales5])

where [Sales1],[Sales2],[Sales3],[Sales4],[Sales5] are other expressions which would calculate Sum(Sales1) etc...

sibusiso90
Creator III
Creator III
Author

How do I get the column name?

prma7799
Master III
Master III

Like this?

sibusiso90
Creator III
Creator III
Author

Guys my output should be

SALES 3

62583110


I got help with getting the value now I need the name Sales3

tresesco
MVP
MVP

To get name of the field you could try like:

= 'Max of totals is in field : ' &

RangeMaxString( Dual('Sales1' , Sum(Sales1)), Dual('Sales2' , Sum(Sales2)), Dual('Sales3' , Sum(Sales3)), Dual('Sales4' , Sum(Sales4)), Dual('Sales5' , Sum(Sales5)) )

& ' and the value is : '

RangeMax( Sum(Sales1),Sum(Sales2),Sum(Sales3),Sum(Sales4),Sum(Sales5) )

prma7799
Master III
Master III

as tresesco‌  suggest I am doing some changes

= 'Max of totals is in field : ' &

RangeMaxString( Dual('Sales1' , Sum(Sales1)), Dual('Sales2' , Sum(Sales2)), Dual('Sales3' , Sum(Sales3)), Dual('Sales4' , Sum(Sales4)), Dual('Sales5' , Sum(Sales5)) )

& ' and the value is : ' &

RangeMax( Max(Sales1),Max(Sales2),Max(Sales3),Max(Sales4),Max(Sales5) )