Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

decimal values

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

21 Replies
Not applicable

Re: decimal values

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.

Not applicable

Re: decimal values

Format as number with precision 2.

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

1.png

For the values

22

22.22634547

22.23


this should result in:


2.png

crusader_
Valued Contributor

Re: decimal values

Hi Rabia,

You should check whether your number has fractional part:

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

Hope this helps.

Andrei

Not applicable

Re: decimal values

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

Not applicable

Re: decimal values

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?

3.png

Not applicable

Re: decimal values

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

Not applicable

Re: decimal values

hi andrei

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

crusader_
Valued Contributor

Re: decimal values

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

Not applicable

Re: decimal values

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

Community Browser