topic Re: K,M in values in App Development

K,M in values

capriconuser — Sat, 16 Nov 2024 07:55:06 GMT

this is the expression

Num(Sum({<FYear = {$(vmax_year)}>}[GPremium]),'#,##0.0')

and this shows like this

19,239,246,925.0 now i want to show here K , L , M, BN

how i do this .. like this

19 BN

Re: K,M in values

ogautier62 — Mon, 23 Jul 2018 09:20:51 GMT

Hi,

here is the beginning, I let you end :

=if(div(w,1000000000)>0,div(w,1000000000) & ' BN ') &

if( mod(w,1000000000) >0,div(mod(w,1000000000),1000000) & ' M ')

regards

Re: K,M in values

ChennaiahNallani — Mon, 23 Jul 2018 09:25:43 GMT

like this

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/NumberInterpretationVariables/NumericalAbbre…

Re: K,M in values

capriconuser — Mon, 23 Jul 2018 09:53:39 GMT

i am trying to do in sense not in qlik view

Re: K,M in values

ChennaiahNallani — Mon, 23 Jul 2018 10:57:25 GMT

watch this video

https://www.youtube.com/watch?v=eDMl1iAPek0

Re: K,M in values

capriconuser — Mon, 23 Jul 2018 11:30:47 GMT

i use set numerical abbreviation but did not working

Re: K,M in values

ChennaiahNallani — Tue, 24 Jul 2018 03:43:13 GMT

share sample QVF file

Re: K,M in values

capriconuser — Tue, 24 Jul 2018 05:47:06 GMT

kindly check attached file

Re: K,M in values

ChennaiahNallani — Tue, 24 Jul 2018 06:12:11 GMT

if(Sum({<[Financial Year] = {$(vmax_year)}>}[Gross Premium]) >= 1000000 and

Sum({<[Financial Year] = {$(vmax_year)}>}[Gross Premium]) <1000000000,

Num((Sum({<[Financial Year] = {$(vmax_year)}>}[Gross Premium])/1000000 ),'#,##.0 M'),

if(Sum({<[Financial Year] = {$(vmax_year)}>}[Gross Premium]) > 1000000000,

Num((Sum({<[Financial Year] = {$(vmax_year)}>}[Gross Premium])/1000000000 ),'#,##.0 B'),

Num(Sum({<[Financial Year] = {$(vmax_year)}>}[Gross Premium]))))

Re: K,M in values

ogautier62 — Tue, 24 Jul 2018 06:40:31 GMT

may be usefull :

to have the letter :

pick( floor(log( 'your amount') / log(1000)),'k','M','B')

and the number :

floor(log( 'your amount') / log(1000))

Re: K,M in values

capriconuser — Tue, 24 Jul 2018 08:02:20 GMT

so what is the use of numerical abbreviation ?