Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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.