Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Max comparing rows over several Dimensions

Hi together,

I have a simple question, but I can not find an easy solution to it.

I want to create a new field in the Load Editor, which gives me the Maximum of the row of 4 different dimensions:

No1No2No3No4Max(No1, No2, No3, No4)

1

2344
67899
98769
72828
45325

Is there a function to create the column "Max(No1, No2, No3, No4)" or do I have to do this by using a lot of comparisions ?

Thanks in advance and best regards

Thorqlik

1 Solution

Accepted Solutions
Highlighted

Re: Max comparing rows over several Dimensions

Try RangeMax() function instead of Max:

RangeMax(No1, No2, No3, No4)

View solution in original post

1 Reply
Highlighted

Re: Max comparing rows over several Dimensions

Try RangeMax() function instead of Max:

RangeMax(No1, No2, No3, No4)

View solution in original post