topic getting integer value while multiplying in QlikView

getting integer value while multiplying

berryandcherry6 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

example: Eq 1 :value = (number of apples * 23 )/5 for this i get number with decimals like 1234.32

Eq 2: value1 = value * 89

While displayinng ''value'' it has to display with decimals ,but while multiplying in equation 2 , i have to multiple with only integer in value1 equation.

How could i achieve this.

Re: getting integer value while multiplying

johnw — Sun, 26 Jun 2016 17:55:55 GMT

If I've understood the question, one of these?

value1 = floor(value)*89

value1 = round(value)*89

value1 = ceil(value)*89

Re: getting integer value while multiplying

berryandcherry6 — Sun, 26 Jun 2016 18:06:39 GMT

Hi johnw ,

value1 = floor(value)*89

This ,Solved my query.

Thanks