
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this
Round(Fabs(If(Profitloss = 'Y', RangeMin(Sum(limitusage), 0), Sum(limitusage))), 0.01)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be like this
Round(Fabs(If(Profitloss = 'Y', RangeMin(Sum(limitusage), 0), Sum(limitusage))))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 )

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this
Round(Fabs(If(Profitloss = 'Y', RangeMin(Sum(limitusage), 0), Sum(limitusage))), 0.01)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks sunny its working...
