Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am new to qlikview.
I have a dimention which needs to convert into million formate.
Example :
202,000,000
I want to show this as
$202M
How can we show this in above formate ?
Thanks!.
maybe
=num(202000000/1000000, '$#.##0M')
for format ('$#.##0M') go to number tab in the chart
thanks.
we does not show decimal place
how can we show number without decimal place ?
=num(202000000/1000000, '$###0M')
thanks it works.
can mark this correct answer and close the thread.
go to number tab and play with format
when you get the format you want, copy in the num function