K,M in values

[capriconuser]

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

[ogautier62]

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

[ChennaiahNallani]

like this

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

[capriconuser]

i am trying to do in sense not in qlik view

[ChennaiahNallani]

watch this video

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

[capriconuser]

i use set numerical abbreviation but did not working

[ChennaiahNallani]

share sample QVF file

[capriconuser]

kindly check attached file

[ChennaiahNallani]

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]))))

[ogautier62]

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))