topic Text in Chart in QlikView

Text in Chart

Wed, 14 Oct 2009 20:51:29 GMT

I added some text to a gauge chart.: = ('Margin: ' &'$'&Sum(Margin)) .

The result of this line is: Margin: $363301,02

Now I'm trying to change the notation to only: Margin: $363.301

I know I can use the NUM function for this, but I dint succeed.
Appreciate the help.

Regards

Wed, 14 Oct 2009 22:12:40 GMT

it should work with num. Show us the code that how you implemented Num function.

It is a bad practice, but you can divide it by 1000 and use round function to deal with decimal.

Ryan

Wed, 14 Oct 2009 23:03:27 GMT

Did you add num like this ? = 'Margin: $' & Sum(num(Margin)) It should work.

Thu, 15 Oct 2009 15:39:02 GMT

Thanks for the tips.

I worked it out the following way to get a satisfying result:

'Margin: $' & NUM(Sum(Margin), '#.##0')