topic Re: Variable for Number format in charts in QlikView

Variable for Number format in charts

kkkumar82 — Mon, 08 Feb 2016 11:15:03 GMT

All,

Can we use a variable which contains a number format rather than the regular format we have.

For eg:

in a chart if we go to number tab - > Money

Can I use a variable like vNumberFormat which contains a format like $#,##;($#,##)

I tired but was not successful.

Any tricks ??

Attaching a sample

Thanks

Kiran

Re: Variable for Number format in charts

sunny_talwar — Mon, 08 Feb 2016 11:19:38 GMT

Not sure if you can alter the format using variable from Number's tab, but you can definitely use the Num() function with a variable:

Re: Variable for Number format in charts

kkkumar82 — Mon, 08 Feb 2016 11:24:21 GMT

Thanks Sunny for your response but rewriting the expression once again using Num() is a burden for me because I have some complicated expressions.

Regards

Kiran kumar

Re: Variable for Number format in charts

avinashelite — Mon, 08 Feb 2016 11:25:37 GMT

As per my knowledge in the Number tab you cannot use, but try like this ...

Directly add the num() function in the expression tab and use the variable to set the format.