Format Currency to 100000K

[ndeeleysww]

Hi,

In QlikSense is it possible to format currency to display to the nearest £1000k?

I'm creating an app for my finance dept and instead of seeing £1,000,000 they'd rather have £1,000 shown, with the (£k) in the title.

I can round the measures and apply a left (5) filter whilst this works most of the time it will skew bar charts and show incorrect values.

Thanks

Neil

[ndeeleysww · Accepted solution]

Sorry! Didn't think about this one. I've just divided the result by 1000 and now have the correct formatting!