Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
grajmca_sgp123
Creator
Creator

how can we write If and Max together

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

1 Solution

Accepted Solutions
maxgro
MVP
MVP

maybe

rangemax(5.41416666666667,0.33,0)

rangemax(a,b,0)

View solution in original post

1 Reply
maxgro
MVP
MVP

maybe

rangemax(5.41416666666667,0.33,0)

rangemax(a,b,0)