topic Re: need change in number in QlikView

need change in number

kunkumnaveen — Wed, 13 Apr 2016 06:11:46 GMT

Hi All

i was showing values on top of each bar ,the problem was each values was about 7 to 8 digit long , so to avoid overlapping of one value on another , i have done this

Number tab-------->number------>precision i chosse 3,

the value i got is some thing like this 6.11e+008 ,what i am looking now is it possible to reduce to digit to 1 or 2 after + symbol instead of 3 digits

plz find the attchment

Re: need change in number

Colin-Albert — Wed, 13 Apr 2016 06:17:50 GMT

Another option is to change the orientation of the bars to horizontal. This allows you to show the value without needing to shorten the number.

Re: need change in number

kunkumnaveen — Wed, 13 Apr 2016 06:23:47 GMT

i known but client wont let me to do that , i mean he wants to display them vertical only

Re: need change in number

maksim_senin — Wed, 13 Apr 2016 06:30:56 GMT

Hi,

Why you don't want to use a possibility to round the values the thousands, millions?

This is possible for each expression at the Number tab of chart properties:

Best regards,

Maxim

Re: need change in number

perumal_41 — Wed, 13 Apr 2016 06:36:15 GMT

how you looking output?

Re: need change in number

kunkumnaveen — Wed, 13 Apr 2016 06:42:22 GMT

i have no particular exception on my o/p but if any thing that can reduce my 7 to 8 digit in to 2 to 3 digits that will be ok

is it possible to change this value 6.11e+008 in to this 6.11+0

Re: need change in number

perumal_41 — Wed, 13 Apr 2016 07:05:05 GMT

try like below

Sum(Field)/1000000

then

change the number format

Re: need change in number

Anonymous — Wed, 13 Apr 2016 07:14:42 GMT

There is a option in Presentation tab,

Values on Data Points.

By checking the option Vertical, you can display the numbers vertically above the respective bars fully without shortening to any format.