Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
i am trying to do in sense not in qlik view
watch this video
i use set numerical abbreviation but did not working
share sample QVF file
kindly check attached file
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]))))
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))