Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

olapaulsson
New Contributor III

Use a dynamic numberformat

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

Tags (1)
1 Solution

Accepted Solutions
pokassov
Valued Contributor

Re: Use a dynamic numberformat

Hello

num(Value,NumberFormat)

Безымянный2.png

View solution in original post

4 Replies
amit_saini
Honored Contributor III

Re: Use a dynamic numberformat

pokassov
Valued Contributor

Re: Use a dynamic numberformat

Hello

num(Value,NumberFormat)

Безымянный2.png

View solution in original post

olapaulsson
New Contributor III

Re: Use a dynamic numberformat

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

Highlighted
olapaulsson
New Contributor III

Re: Use a dynamic numberformat

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