Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
ndeeleysww
Creator
Creator

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
Creator
Creator
Author

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

View solution in original post

1 Reply
ndeeleysww
Creator
Creator
Author

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