decimal values

[#1]

Im new to qlikview.

i want to value in the chart like

22 = 22

and

22.22634547 = 22.23

but qlikview always show the value in the format

22 = 22.00

22.22634547 = 22.23

[#2]

Hi,

In the properties of your object (right click on the object -> properties) you have a "Number" window, in this window, you can specify how many decimals you want.

[#3]

Format as number with precision 2.

The format pattern should look like "#,###"

For the values

22

22.22634547

22.23

this should result in:

[crusader_]

Hi Rabia,

You should check whether your number has fractional part:

if(frac(Number)=0, num(Number,'###'), num(Number,'###,##'))

Hope this helps.

Andrei

[#5]

hi there;
thanks for reply but i need this to be done in my chart, i made a chart and its not showing values in two decimals, as in, if i select fixed to 2 decimal values it shows 22.00 rather than the actual point value it must show(22.45), i dunno how to solve that. do share if yu've ever came across this

[#6]

Rabia,

it's the same setting: right click, choose properties, number. Make sure you select "Override document settings", choose type "Number" and 2 as precision. If needed you can override the default format pattern to "##,##"

I assume the value is used as an expression and not a dimension?

[#7]

I tried the number format, its showing me 22.00. and yes value is used as an expression.

[#8]

hi andrei

ive three expressions, so shall i paste this above code in all three of the expressions? 

[crusader_]

Hi Rabia,

You should paste this code in all expression which you want to be shown in such manner.

If there are 3 expressions - paste them instead "Number" in above code.

Hope this helps.

Andrei

[#10]

What is the number format used in 'Number' tab??