Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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