Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
KPI is showing sum(sales ) as 1.58M, is it possible to convert it in number formatting to 1.6M.
In KPI I have used number formatting as Auto.
Hi, if this sum(sales) number is static (or always be in millions), you can try something like this:
num( sum(sales) / 1000000 , '#.0M')
if it is dynamic, you can try something like this:
dual(num(sum(Sales)/pow(10,3*floor(log10(sum(Sales))/3)),'#.0'&pick(floor(log10(sum(Sales))/3),'k','M','B')),sum(Sales))
but change Number formatting to 'Measure expression' with this.
Hi, if this sum(sales) number is static (or always be in millions), you can try something like this:
num( sum(sales) / 1000000 , '#.0M')
if it is dynamic, you can try something like this:
dual(num(sum(Sales)/pow(10,3*floor(log10(sum(Sales))/3)),'#.0'&pick(floor(log10(sum(Sales))/3),'k','M','B')),sum(Sales))
but change Number formatting to 'Measure expression' with this.
Hi @Qlik1_User1 ,
Change the below format patter property as per your requirement.
@justISO but sum(sales ) less than 1000 is getting missed by this expression.