Discussion Board for collaboration related to Creating Analytics for QlikView.
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 [
Go to Solution.
View solution in original post
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.
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!