topic round() function in QlikView

round() function

Mon, 19 Apr 2010 09:53:23 GMT

I'm using round() in a text-in-chart text to display a number as x.y . It is working fine in Qlikview developer, but when I open the document through the webserver portal, round() displays the same number as x, ignoring my base parameter. My mistake or .... ?

round() function

Mon, 19 Apr 2010 09:57:55 GMT

Hi,

Check both the versions of developer & Plugin are same. You can make use of number format to round it to the upper value as an alternate solution.

Regards

Rajesh

round() function

Mon, 19 Apr 2010 11:14:00 GMT

Versions differ slightly in build number, but I don't want to upgrade my QV server software right now.

I'm not sure I understand your number format solution, as I want to keep the decimal and not simply round up. Could you show me an example how to simulate round(x.abcdef, 0.1) using number formatting?

Thanks.

round() function

Tue, 20 Apr 2010 02:00:35 GMT

Try to use format

Num(X.abcd,'#0.0')