Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
satishkamath
Creator II
Creator II

Custom number format with variable

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

5 Replies
Not applicable

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

satishkamath
Creator II
Creator II
Author

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.

mov
Champion III
Champion III

No quotes needed:

num(<expression>, vDivision)

satishkamath
Creator II
Creator II
Author

Thanks Michael & Joe for your valuable suggestion

Not applicable

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