how can we write If and Max together

grajmca_sgp123 — Sun, 23 Aug 2015 08:31:48 GMT

Hi all

How can we write below If and Max condition together in qlikview.

if(Max(a,b))<0,0, max(a,b))

example:

if(Max(5.41416666666667,0.33))<0,0, max(5.41416666666667,0.33))

Result should be 5.41416666666667

Thanks in advance

Re: how can we write If and Max together

maxgro — Sun, 23 Aug 2015 08:54:58 GMT

maybe

rangemax(5.41416666666667,0.33,0)

rangemax(a,b,0)