topic Re: Use a dynamic numberformat in QlikView

Use a dynamic numberformat

Amphan — Thu, 16 Apr 2015 06:28:41 GMT

Is it possible to use a dynamic numberformat, ie. use a format stored in a field to format another field.

For example, if I have tha data below, could I somehow use the expression =num( [Value] , '[numberformat]' );

LOAD * INLINE [

Value, NumberFormat

"0,7511", "#0,00%"

"0,5012", "#0,0"

];

TIA

//Ola

amit_saini — Thu, 16 Apr 2015 06:33:16 GMT

Try this:

Thanks,
AS

pokassov — Thu, 16 Apr 2015 06:41:29 GMT

Hello

num(Value,NumberFormat)

Amphan — Thu, 16 Apr 2015 06:42:09 GMT

Thanks, but that example does not use the actual value from a field as the numberformat.

I am looking for a way to pick the fieldvalue of [NumberFormat] and use it as the formatting parameter in the num function.

//Ola

Amphan — Thu, 16 Apr 2015 06:46:31 GMT

Thank you, it works!

I actually tried num(Value,'NumberFormat') and it did'nt work but now I understand that those pesky quotes are'nt needed!

Thank you!

//Ola