Solved: number formate in text box... - Qlik Community

Report Inappropriate Content · ‎2012-01-20

hi all,

I am displaying the sum of amount in text box by using regular expression. which is showing like $ 10000

I want this number to show with proper format i.e ($1,00,00)...... any suggtion.?

no number tab available in text box property.....

vijay_iitkgp · ‎2012-01-20

Hi,

You can use Num(value,'$#,##0.00;($#,##0.00)')

nstefaniuk · ‎2012-01-20

When you say "text box", you mean "Input box" or an other object?

vijay_iitkgp · ‎2012-01-20

Hi,

You can use Num(value,'$#,##0.00;($#,##0.00)')

vijay_iitkgp · ‎2012-01-20

You can also use =Money(Value)

Report Inappropriate Content · ‎2012-01-22

thnsk thats what i want..... thanks to other too..

number formate in text box...