Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Try using '##.00'
# = show if required
0= always show