topic Help with Max function in QlikView

Help with Max function

Mon, 13 Jul 2015 12:19:39 GMT

Hi Guy's

I am trying to use the max function as per the following. The problem comes in is when one of these values is zero or null then it will not add. Is this normal ? Script below and thank you for your help in advance.

max(If([Authorisation Type] = 1 and [Product Style Code] = 'Unsound with NO VALUE - Sinkers', [Prec of SKR]))

max(If([Authorisation Type] = 1 and [Product Style Code] = 'Unsound with NO VALUE - Mould', [Prec of SKR]))

max(If([Authorisation Type] = 1 and [Product Style Code] = 'Oil Nuts Value', [Prec of SKR]))

Re: Help with Max function

MK_QSL — Mon, 13 Jul 2015 12:21:17 GMT

Max(Alt(YourExpression,0)) + Max(Alt(YourExpression,0)) + Max(Alt(YourExpression,0))

But I think something wrong with your expression.

Either you need to use RangeMax(with All your three formulas here) or you are missing Aggr

RangeMax(If([Authorisation Type] = 1 and [Product Style Code] = 'Unsound with NO VALUE - Sinkers', [Prec of SKR]))

(If([Authorisation Type] = 1 and [Product Style Code] = 'Unsound with NO VALUE - Mould', [Prec of SKR]))

(If([Authorisation Type] = 1 and [Product Style Code] = 'Oil Nuts Value', [Prec of SKR]))

Re: Help with Max function

sunny_talwar — Mon, 13 Jul 2015 12:29:10 GMT

May be try this:

RangeSum(

max(If([Authorisation Type] = 1 and [Product Style Code] = 'Unsound with NO VALUE - Sinkers', [Prec of SKR])),

max(If([Authorisation Type] = 1 and [Product Style Code] = 'Unsound with NO VALUE - Mould', [Prec of SKR])),

max(If([Authorisation Type] = 1 and [Product Style Code] = 'Oil Nuts Value', [Prec of SKR])))

Re: Help with Max function

Mon, 13 Jul 2015 12:35:11 GMT

Thanks so much , worked perfectly

Re: Help with Max function

sunny_talwar — Mon, 13 Jul 2015 12:35:49 GMT

Awesome

I am glad I was able to help.

Best,

Sunny