Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Automatic calculation

Hey All,

I'm working on a Qlikview Document and I want to make an automatic sum, but I can't seem to figure out how to do it...

It works like this: I've got a number that consists of 2 different numbers: like 5.1 or 4.2

the second number can only be 0, 1 or 2 because everything above that would be divided by 3 and the rest would be 0, 1 or 2 again. So imagine I have:

4.2+5.1 then it have to be 10.0, but now it is 9.3

Can someone help me?

Thanks in advance

1 Reply
sujeetsingh
Master III
Master III

Hi,

You can use Ceil()  or Floor() functions.