Skip to content

Instantly share code, notes, and snippets.

@ralfbecher

ralfbecher/QlikView_Expression_to_format_Numbers_with_Factor_Denote.qvw

Created December 11, 2013 10:14
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ralfbecher/7908033 to your computer and use it in GitHub Desktop.
Save ralfbecher/7908033 to your computer and use it in GitHub Desktop.
Download ZIP
QlikView Expression to format Numbers with Factor Denote (eg. 100M, 200k)
Raw
QlikView_Expression_to_format_Numbers_with_Factor_Denote.qvw
=If(Value > 1E6, Round(Value/1E6, 1) & 'M',
If(Value > 1E3, Round(Value/1E3, 1) & 'k',
Value))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment