Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Amphan
Contributor III
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

1 Solution

Accepted Solutions
pokassov
Specialist
Specialist

Hello

num(Value,NumberFormat)

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

View solution in original post

4 Replies
amit_saini
Master III
Master III

pokassov
Specialist
Specialist

Hello

num(Value,NumberFormat)

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

Amphan
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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