# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

## Max and Min function on an expression within a table

I am fairly new to Qlikview, certainly interms of slightly more advanced calculations etc.  Hope someone can help:

I have a chart table with the following columns/rows - see attached picture.

'Ability' is an expression based on a simple a/b formula

I wish to create a variable called 'Max Ability' which returns a constant of the max ability value for all rows.

It could even be another expression, rather than a variable.

I have tried various things but cannot get any to work.  My attempt at creating a Max Ability Epxression in another column returned teh same values as the Ability column itself!!

I'm sure this is probably very easy - can someone please put me on the right path?

Thanks

3 Replies
Valued Contributor

## Re: Max and Min function on an expression within a table

Hi tim,

You can achieve that using the parameter TOTAL in the aggregation, i.e.: sum(total A)/sum(total B).

Hope this helps you,
Cesar.

Not applicable

## Re: Max and Min function on an expression within a table

Hi Cesar - Thanks for your input.

But this just seems to give me an average figure:

SUM(TOTAL[Rules Races Winnings]/SUM(TOTAL[Rules Races Wins])/100)

Which gives answer =42 and it should be = 66

What did I do wrong?

Honored Contributor II

## Re: Max and Min function on an expression within a table

Hi,

Try:

MAX(TOTAL SUM([Rules Races Winnings]/([Rules Races Wins]/100)))

Hope this helps,

Jason