topic Limit Char in QlikView

Limit Char

Wed, 11 Apr 2012 13:21:24 GMT

Hey hey,

basically i have :

count({<Q2LastYearScore = {1}>} responseid) /count({<Q2LastYearScore = {3}>} responseid)

in a text box, but want to limit the result to 2 decimal places, what is the best way to go about this ???

swuehl — Wed, 11 Apr 2012 13:35:39 GMT

maybe

=num(

count({<Q2LastYearScore = {1}>} responseid) /count({<Q2LastYearScore = {3}>} responseid)

,'#.00')

or use one of the functions round(), floor(), ceil() with an appropriate base / step.

CELAMBARASAN — Wed, 11 Apr 2012 13:38:17 GMT

Hi,

Check with it

=Num(count({<Q2LastYearScore = {1}>} responseid) /count({<Q2LastYearScore = {3}>} responseid),'###.##')

Celambarasan