topic Rounding up text in Qlikview in QlikView

Rounding up text in Qlikview

KimFerguson — Fri, 10 Jun 2022 03:59:30 GMT

I am trying to round up the outcome of the text below. I know the € #.##0 probably needs to be placed at the ends, but I can not get it to work icw to the brackets etc. Thank you in advance.

=if(SUM(EM)>= 400000, 

num((((SUM(EM)-400000)*0.0118)+12000),'€ #.##0')/count(DISTINCT PersonId),

num(SUM(EM)*0,03,'€ #.##0')/count(DISTINCT PersonId)

)

Culver's Guest Satisfaction Survey

Re: Rounding up text in Qlikview

marcus_sommer — Thu, 09 Jun 2022 08:41:36 GMT

num() doesn't round else formats a value and it must be the most outside-part of an expression to get to applied. If really a rounding is needed you may use round/ceil/floor. Further the second multiplicator is wrongly set (comma instead a dot as decimal-delimiter and the expression is more complex as needed and might be look like:

=num(if(SUM(EM)>= 400000, 
(((SUM(EM)-400000)*0.0118)+12000), SUM(EM)*0.03)/count(DISTINCT PersonId)
,'€ #.##0')

- Marcus

Re: Rounding up text in Qlikview

Daniel044 — Sat, 11 Jun 2022 03:25:23 GMT

Round() returns the result of rounding x up or down to the nearest multiple of step [+ offset]. The default value of offset is 0. The default value of step is 1. HCA Rewards Login