Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Paknanarn23
Creator II
Creator II

I want the values ​​to be displayed like this.

I want the value of column 2 to be output like this: if column 1 is greater than 4320 then display the value in column 2 as 4320 and if column 1 is less than 30 then display the value 30 in column 2.

Now I can only if the value is less than 30 then it shows 30, but not greater than 4320 yet.

Paknanarn23_1-1677206184744.png

 

Paknanarn23_0-1677206094089.png

 

1 Solution

Accepted Solutions
Aditya_Chitale
Specialist
Specialist

Try this :

if(sum(Column1)<30 , '30' , if(sum(Column1)>4320, '4320' , sum(Column1)))

Regards,

Aditya

View solution in original post

1 Reply
Aditya_Chitale
Specialist
Specialist

Try this :

if(sum(Column1)<30 , '30' , if(sum(Column1)>4320, '4320' , sum(Column1)))

Regards,

Aditya