decimal values

[#1]

Im new to qlikview.

i want to value in the chart like

22 = 22

and

22.22634547 = 22.23

but qlikview always show the value in the format

22 = 22.00

22.22634547 = 22.23

[#2]

Hi Rabia,

You can try as below in the expression and set the Number format as "Expression Default"

=if(frac(Sales)=0,Num(Sales,'#,##0'),Num(round(Sales,0.01),'#,##0.00'))

Thanks,

TDP

[ThornOfCrowns]

Try using '##.00'

# = show if required

0= always show