1 Reply Latest reply: May 15, 2015 5:53 AM by Neil Deeley RSS

    Format Currency to 100000K

    Neil Deeley

      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