Discussion Board for collaboration on QlikView Scripting.
Hi to all,
I have the following data:
The sum of A1-B2 where group3 = X,Y,Z, W is 100 and the same for A2-B2.
I need to get the field val as an integer and still have the total to 100.
the result can be something like:
Any idea to reach that?
Hi use the CEIL function
NUM(CEIL(val, 0.1), '#.#00')