topic Chart Help ?? in QlikView

Chart Help ??

Mon, 24 Jan 2011 17:02:41 GMT

I have 'Sales' field with the following values :

Sales

9500

22850

30195

108000

But the actual values are:

95.00

228.50

301.95

1080.00

For example, '9500' Field value should be convert to 95.00 in Chart.

How can I do this in Chart ??

Can anyone help ???

Many thanks

matt_crowther — Mon, 24 Jan 2011 17:18:03 GMT

Divide 'Sales' by 10 in the expression and set the Number format to be 'Fixed To' 2 decimal places.

Works for me.

Hope that helps,

Matt - Visual Analytics Ltd

Mon, 24 Jan 2011 17:26:22 GMT

You can transform your field:

=LEFT(Sales, Len(Sales)-2) & '.' & Right(Sales, 2)

Mon, 24 Jan 2011 17:33:26 GMT

Thanks Matt !!

Your Solution working fine for me...

I Divided the Sales by 100...not 10.

For example, If i divide 9500 by 10 ..the value i get 950...but i want 95. So i divide the value by 100.

Thanks a lot ...