Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ndeeleysww
Contributor

Format Currency to 100000K

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


1 Solution

Accepted Solutions
ndeeleysww
Contributor

Re: Format Currency to 100000K

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

1 Reply
ndeeleysww
Contributor

Re: Format Currency to 100000K

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