topic Displaying up to 2 decimal values in QlikView

Displaying up to 2 decimal values

Wed, 12 Nov 2014 07:18:19 GMT

Hi all,

I have a small function as sum(Runs)/Count(Dismissal). The o/p is coming in decimal points.

I want to show the o/p only up to 2 decimal points. I have tried with num#,round etc functions

but didn't get o/p as required. Please suggest me how to do it?

Thanks,

Shailesh

Wed, 12 Nov 2014 07:22:03 GMT

where u want to show in chart or text box?

in chart means go to number tab >select integer or number which u want > give decimals also upto how many u want

if in list box

try like this

ceil(534.465,0.5) then output like > 534.46

SergeyMak — Wed, 12 Nov 2014 07:25:59 GMT

Hi,

Try this

Num(sum(Runs)/Count(Dismissal),'#,##0.00 ')

Regards,

Sergey

Wed, 12 Nov 2014 07:30:36 GMT

Expr: sum(Runs)/Count(Dismissal)

GO to Number Tab in the Chart...Select Fixed to : 2

Regards,

Heather

ashishkalia — Wed, 12 Nov 2014 07:39:25 GMT

PLEASE CHECK ATTACH QVD THIS MAY HELP U....

CHEERS....

Wed, 12 Nov 2014 07:56:53 GMT

Thank you Ashish..

Rgds,

Shailesh