Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Money Value '2.33G'. But I want to convert it into 'M' so what is Expression for it.
What is G here?
I suppose it's billion like "giga"
Just divide by 1000 ?
multiply !
That might work
Actually you should import that xxxG value as a regular (altho large) number into QlikView, and use the Number formatting fields to display it in a different format. That way you can still perform arithmetic or aggregation on its actual value.