Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

round() with if logic help

Hi Experts,

Can any one please help me to create below oracle expression in Qlik

here profitloss  and limitusage are fields.

round(abs(

case

   when profitloss = 'Y' then least(sum(  [limitusage] )  , 0)

else

  sum( [limitusage] )

end)  , 2 )

Thanks in advance.

1 Solution

Accepted Solutions
sunny_talwar

May be this

Round(Fabs(If(Profitloss = 'Y', RangeMin(Sum(limitusage), 0), Sum(limitusage))), 0.01)

View solution in original post

4 Replies
sunny_talwar

May be like this

Round(Fabs(If(Profitloss = 'Y', RangeMin(Sum(limitusage), 0), Sum(limitusage))))

mahitham
Creator II
Creator II
Author

Hi Sunny,

Thanks for your reply its rounding by 2 digits where to apply 2 in your expression also in the query mentioned abs not fabs.

round(abs(

case

  when profitloss = 'Y' then least(sum(  [limitusage] )  , 0)

else

  sum( [limitusage] )

end)  , 2 )

sunny_talwar

May be this

Round(Fabs(If(Profitloss = 'Y', RangeMin(Sum(limitusage), 0), Sum(limitusage))), 0.01)

mahitham
Creator II
Creator II
Author

Thanks sunny its working...