Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master

rounding of zero-values

Hi Folks,

i know, there are no a funny questions, but i have got a situation:

my value does look like: -0,07 , i tried to implement with the help of other functions like : Round and Ceil but i didn't achieve any solutions.

how can i round it to 0 (to zero without minus-sign)

Thanks a lot for your feedback and help

Beck

17 Replies
Anonymous
Not applicable

vijetas42
Specialist
Specialist

Hi,

try function fabs()

ahaahaaha
Partner - Master
Partner - Master

May be

Can be at coloring to specify separately one of conditions, like this?

If(Value=0, Black())

beck_bakytbek
Master
Master
Author

i had already done,

Thanks a lot for your feedback

beck_bakytbek
Master
Master
Author

Hi Andrey,

i will create my example with fake-values and show you

Thanks a lot

Beck

p.s: Spasibo Bolshoe sa pomosh i poddershku

ahaahaaha
Partner - Master
Partner - Master

Thank you for your kind words. 🙂

Look attached file with example variant of coloring.

beck_bakytbek
Master
Master
Author

Thanks a lot Andrey

Spasibo Bolshoe

Beck

ahaahaaha
Partner - Master
Partner - Master

Was glad to help. Have a good day.