Discussion board where members can get started with Qlik Sense.
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.
Go to Solution.
Sorry! Didn't think about this one. I've just divided the result by 1000 and now have the correct formatting!