Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
raghavsurya
Partner
Partner

Min or Max of two columns in table

Hi All,

I have a requirement wherein I need to pick Min or Max of two tables Sales, services.  Below is a small example provided.

CitySalesServices
London10050
Paris60
Zurich200

I need to pick Min value of Sales and Services together in one expression which is 50.

Can anybody suggest how to get it done.

Regards,

Raghav

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try

=RangeMin(Min(Sales),Min(Services))

View solution in original post

2 Replies
swuehl
MVP
MVP

Try

=RangeMin(Min(Sales),Min(Services))

View solution in original post

CELAMBARASAN
Partner
Partner

Hi,

     Use Range functions for multiple columns.

     RangeMin(Min(Sales),Min(Services))

     RangeMax(Max(Sales),Max(Services))

Celambarasan