topic Re: Custom number format with variable in QlikView

Custom number format with variable

Anonymous — Thu, 05 Feb 2015 17:19:54 GMT

I have expression

Num((Sum({$<QUARTER = {99}>} jATTRIBUTE_VALUE)/1000000), '#,##0.00;(#,##0.00)')
But instead of two decimal, I want option to select how many decimal end user wants. So I applied as below in red

Num

((Sum({$<QUARTER = {99}>} jATTRIBUTE_VALUE

)/1000000), '$(=vDivision)') Where vDivision is variable and value for this is

#,##0.00;(#,##0.00)

But it does not work

Is there any way to apply variable

Thanks in advance

Re: Custom number format with variable

Thu, 05 Feb 2015 17:33:59 GMT

Hi Satish,

if the variable is just set like that you don't need to dollar expand it, just use.

you only would need to dollar expand if the variable contained an expression and you wanted to use the result from it.

((Sum({$<QUARTER = {99}>} jATTRIBUTE_VALUE

)/1000000), vDivision)

hope that helps

Joe

Re: Custom number format with variable

Anonymous — Thu, 05 Feb 2015 18:11:03 GMT

Hi Joe

I used as below

((

Sum({$<QUARTER = {99}>} jATTRIBUTE_VALUE

)/1000000), 'vDivision') where vDivision is

'#,##0.00;(#,##0.00)' is variable

I am not getting required result but all zeroes. Am I making any mistake here?

Thanks for your time and follow up.

Re: Custom number format with variable

Anonymous — Thu, 05 Feb 2015 18:31:37 GMT

No quotes needed:

num(<expression>, vDivision)

Re: Custom number format with variable

Anonymous — Thu, 05 Feb 2015 18:52:41 GMT

Thanks Michael & Joe for your valuable suggestion

Re: Custom number format with variable

Fri, 06 Feb 2015 08:41:47 GMT

Yea as Michael says no quotes, I missed taking the second one away in my post sorry, have edited now

Re: Custom number format with variable

NadiaB — Thu, 12 May 2022 15:40:08 GMT

Hi @Anonymous

I just tested and it works fine:

Variable Value (vFormat sample variable):

#,##0.0000;(#,##0.0000)

Expression:

=Num( 12345670000, '$(vFormat)')

Kind Regards,