topic Re: Text Formatting for Text Field Expression in QlikView

Text Formatting for Text Field Expression

Mon, 17 Sep 2012 11:28:48 GMT

Is it possible to format the result of an expression in a text field? I would like the output to be in a currency format rather than just a regular number with unlimited decimal places.

Re: Text Formatting for Text Field Expression

Miguel_Angel_Baeyens — Mon, 17 Sep 2012 11:32:03 GMT

Hi,

Yes, you can use the Money() function, or even the Num() function like this:

=Money(Sum(Sales))

Hope that helps.

Miguel

Re: Text Formatting for Text Field Expression

Mon, 17 Sep 2012 12:04:26 GMT

and what if id like the currency without the pence?

Re: Text Formatting for Text Field Expression

Mon, 17 Sep 2012 12:06:47 GMT

Num(Sum(Sales),'£#,###')

Re: Text Formatting for Text Field Expression

Miguel_Angel_Baeyens — Mon, 17 Sep 2012 12:08:14 GMT

Hi,

Then use the Num() with the format you want. Say the value is 10000 and you want to represent it like "$10,000" or the value is -2300 and you want to represent it like "($2,300)", then the format should be:

=Num(Sum(Sales), '$#,##0;($#,##0)')

Hope that helps.

Miguel

Re: Text Formatting for Text Field Expression

Mon, 17 Sep 2012 12:09:55 GMT

Miguel thats excellent, thank you so much for your help.