topic Re: How the number format conversion will automatically changes from Mn\Bn....? in QlikView

How the number format conversion will automatically changes from Mn\Bn....?

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

In my current dashboard i want to display the sum(revenue) figure.In such case based on the number count it should automatically change the number format text from Million/Billion .

The current expression used for that: text(money(Sum(dollar_value_sold)/1000000000)&'Mn')

Regards,

Venugopal G

Re: How the number format conversion will automatically changes from Mn\Bn....?

swuehl — Tue, 26 Apr 2016 16:34:16 GMT

Not quite sure if I got your request right, maybe like this?

dynamically changing scale in text box

Re: How the number format conversion will automatically changes from Mn\Bn....?

Wed, 27 Apr 2016 09:08:53 GMT

Hi Swuehl,

Thanks for your reply.....

Awesome it is working fine for me..Need small change in Expression if possible

I want to display the number as separate text object and Bn\Mn conversion as separate text.If you provide the expression that will be great help.

Above image for your reference.

Regards,

Venugopal G

Re: How the number format conversion will automatically changes from Mn\Bn....?

swuehl — Wed, 27 Apr 2016 15:30:15 GMT

If you look at this expression sample for example:

=num( sum( revenue) /pow(1000,floor(log10(fabs(sum(revenue)))/3)),'##0.000')

& pick(floor(log10(fabs(sum(revenue)))/3)+1,'',' thousand',' million',' billion',' trillion')

you can easily split it into two parts / text box expressions:

=num( sum( revenue) /pow(1000,floor(log10(fabs(sum(revenue)))/3)),'##0.000')

= pick(floor(log10(fabs(sum(revenue)))/3)+1,'',' thousand',' million',' billion',' trillion')

Re: How the number format conversion will automatically changes from Mn\Bn....?

MK9885 — Wed, 24 Aug 2016 17:37:23 GMT

I've been trying to do same thing in Qlikmaps, represent the number in M but this seems not to work. any idea or is this only valid for Straight Table?