topic Re: how to enable the billion and trillian format in QlikView

how to enable the billion and trillian format

Wed, 25 Sep 2013 06:12:26 GMT

Hi team

kindly guide me how to enable the trillian and billion format.

Re: how to enable the billion and trillian format

jagan — Wed, 25 Sep 2013 06:43:17 GMT

Hi Srinivasan,

Just put a symbol like B in the text box for Billion, M for Million, K for Thousand. Qlikview will automatically measure the axes based on the values, but there is no option for Trillion, if you need then you need to do manually by dividing 1 trillion to the expression.

Regards,

Jagan.

Re: how to enable the billion and trillian format

Wed, 25 Sep 2013 06:43:18 GMT

Hi,

If you mean that the symbol boxes are freezed and you are not able to add a symbol there then make sure that its a chart (not a table)and make the expression's format as money.

You can refer to this thread: http://community.qlik.com/thread/91302

Hope this helps!

Re: how to enable the billion and trillian format

Wed, 25 Sep 2013 06:45:42 GMT

Not sure about Trillion but to enable Billion, just enter a B or whatever character represents this value best for you

Re: how to enable the billion and trillian format

Wed, 25 Sep 2013 06:52:20 GMT

what ever option i selected, thousand and billion input boxes are not enabled... Is there any specific option i need to set

Re: how to enable the billion and trillian format

Wed, 25 Sep 2013 06:53:34 GMT

this option i need to set for a particular column like opening balance, closing balance etc. at the grid level.

Re: how to enable the billion and trillian format

Wed, 25 Sep 2013 06:54:12 GMT

Refer to my reply above. Your object should be chart and not a table then only these options will be enabled.

Re: how to enable the billion and trillian format

Wed, 25 Sep 2013 06:57:14 GMT

Thanks Shyam

Re: how to enable the billion and trillian format

Wed, 25 Sep 2013 07:04:02 GMT

Hi Srinivasan,

Does this resolve your issue? If so can you please mark the correct/helpful answer, so it will be useful for others who come across this thread.

Re: how to enable the billion and trillian format

MarcoWedel — Mon, 30 Jun 2014 20:24:22 GMT

might be a bit late

but maybe also helpful:

SET vSize = Div(Log10($1),3);
SET vFormatNumber = Dual(Num($1/Pow(10,3*$(vSize($1))),'#,##0')&' '&Pick($(vSize($1)),'K','Mil','Bil','Tril'),$1);

LOAD *,
     $(vFormatNumber(parameter)) as paramFormat;
LOAD pow(10,Rand()*14) as parameter
AutoGenerate 30;

regards

Marco